Mixed collations after testing upgrade to v4

[Thomas P]

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