Thomas P Posted January 10, 2016 Posted January 10, 2016 Hello after testing the upgrade process on our IP.Board 3.4.9 to IPB 4.1.x (latest) I see mixed collations. The UTF8 Converter stated: "The database tables are UTF-8, collations are correct and there is nothing to convert. You can proceed with the upgrade." Upgrade run fine, but now I see mixed collations, like e.g.: ipb_conv_link_topics utf8mb4_unicode_ci ipb_core_acp_search_index utf8_unicode_ci ipb_core_acp_tab_order utf8_unicode_ci ipb_core_acronyms utf8mb4_unicode_ci ipb_core_admin_login_logs utf8mb4_unicode_ci ipb_core_admin_logs utf8mb4_unicode_ci ipb_core_admin_permission_rows utf8mb4_unicode_ci ipb_core_advertisements utf8_unicode_ci When running UTF8 Converter Tools after the upgrade the output is as follows: 86 tables are utf8mb4 57 tables are utf8 0 tables have incorrect collations Why is that, I guess this shouldn't be mixed collations... How can I fix this, I can easily convert the tables myself if this is safe to be done, but it is a PITA to convert the columns as well manually... Thanks, Thomas
Recommended Posts
Archived
This topic is now archived and is closed to further replies.