Database naar utf8mb4 converteren zonder SSH

Master

Administrator
Medewerker
Indien de XenForo database niet in het utf8mb4 formaat staat is het niet mogelijk om de emoji's te gebruiken.
Het converteren van de database kan vaak via SSH. Indien deze optie niet beschikbaar is kan dit ook rechtstreeks in phpMyAdmin (wat ik zelf met de databases van dit forum en een ander XenForo forum succesvol heb gedaan).

- Log in op phpMyAdmin en selecteer de gewenste database.
- Maak eerst een back-up van de database. Indien er iets fout gaat bij het converteren kan deze back-up weer terug geplaatst worden.
- Klik op SQL en plak dan onderstaande code in het invoerveld:
SQL:
ALTER TABLE xf_addon CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_addon_install_batch CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_admin CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_admin_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_admin_navigation CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_admin_permission CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_admin_permission_entry CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_advertising CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_advertising_position CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_api_attachment_key CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_api_key CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_api_key_scope CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_api_scope CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_approval_queue CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_attachment CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_attachment_data CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_attachment_view CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_ban_email CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_bb_code CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_bb_code_media_site CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_bookmark_item CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_bookmark_label CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_bookmark_label_use CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_captcha_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_captcha_question CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_category CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_change_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_class_extension CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_code_event CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_code_event_listener CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_connected_account_provider CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_content_spam_cache CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_content_type_field CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_conversation_master CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_conversation_message CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_conversation_recipient CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_conversation_user CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_cron_entry CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_css_cache CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_data_registry CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_deletion_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_draft CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_editor_dropdown CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_edit_history CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_email_bounce_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_email_bounce_soft CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_error_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_feed CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_feed_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_file_check CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_find_new CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_find_new_default CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_flood_check CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_forum CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_forum_field CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_forum_prefix CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_forum_prompt CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_forum_read CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_forum_watch CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_help_page CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_image_proxy CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_image_proxy_referrer CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_import_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_ip CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_ip_match CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_job CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_json_convert_error CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_language CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_link_forum CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_link_proxy CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_link_proxy_referrer CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_login_attempt CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_mail_queue CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_member_stat CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_moderator CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_moderator_content CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_moderator_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_navigation CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_navigation_type CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_news_feed CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_node CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_node_type CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_notice CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_notice_dismissed CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_oembed CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_oembed_referrer CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_option CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_option_group CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_option_group_relation CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_page CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_payment_profile CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_payment_provider CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_payment_provider_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_permission CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_permission_cache_content CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_permission_combination CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_permission_combination_user_group CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_permission_entry CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_permission_entry_content CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_permission_interface_group CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_phrase CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_phrase_compiled CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_phrase_map CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_poll CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_poll_response CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_poll_vote CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_post CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_profile_post CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_profile_post_comment CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_purchasable CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_purchase_request CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_reaction CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_reaction_content CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_registration_spam_cache CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_report CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_report_comment CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_route CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_route_filter CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_search CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_search_index CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_session CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_session_activity CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_session_admin CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_session_install CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_sitemap CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_smilie CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_smilie_category CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_spam_cleaner_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_spam_trigger_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_stats_daily CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_style CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_style_property CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_style_property_group CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_style_property_map CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_tag CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_tag_content CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_tag_result_cache CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_template CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_template_history CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_template_map CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_template_modification CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_template_modification_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_template_phrase CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_tfa_attempt CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_tfa_provider CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_thread CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_thread_field CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_thread_field_value CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_thread_prefix CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_thread_prefix_group CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_thread_prompt CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_thread_prompt_group CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_thread_read CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_thread_redirect CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_thread_reply_ban CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_thread_user_post CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_thread_view CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_thread_watch CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_tl_user_smilie CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_trophy CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_unfurl_result CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_upgrade_check CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_upgrade_job CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_upgrade_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_alert CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_alert_optout CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_authenticate CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_ban CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_change_temp CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_confirmation CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_connected_account CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_field CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_field_value CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_follow CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_group CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_group_change CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_group_promotion CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_group_promotion_log CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_group_relation CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_ignored CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_option CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_privacy CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_profile CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_push_optout CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_push_subscription CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_reject CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_remember CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_tfa CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_tfa_trusted CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_title_ladder CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_trophy CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_upgrade CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_upgrade_active CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_user_upgrade_expired CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_warning CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_warning_action CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_warning_action_trigger CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_warning_definition CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_widget CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_widget_definition CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
ALTER TABLE xf_widget_position CONVERT TO CHARACTER SET utf8mb4   COLLATE utf8mb4_unicode_ci;
 
Bovenaan