#102667BE Module Reports show"illegal mix of collations" Message
Description
The message “illegal mix of collations” is shown if the BE Modul Webreactions or Webhooks is installed.
Because both modules creates a db table with a field using a differente collation:
sys_reaction.fields use the collation utf8mb4_bin and sys_webhook.additional_headers use the collation utf8mb4_bin also
But the default collation is “utf8mb4_unicode_ci”
This results in a error message inside the BE Reports Module:
our default database is set to create tables with character set "utf8mb4_unicode_ci", but contains tables or columns with different collations. Please fix these tables to avoid "illegal mix of collations" errors.
i dont have taken a deeper look if the different collation is necessary for the db fields (imho sorting and comparing) but this message is maybe a false positive or could be confusing some users
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.
Files 1
History 3
-
Garvin Hicking commented and changed status
NewNeeds Feedback 06/16/24, 19:40 -
Benni Mack changed category 06/19/24, 20:56
-
Garvin Hicking commented and changed status
Needs FeedbackClosed 06/25/24, 14:38The TYPO3 core itself doesn’t define utf8mb4_bin itself, so this is most likely a problem in the order of database operations or performing import/export with changes of default collations.
Ideally you should ensure that utf8mb4_unicode_ci is used everywhere.
The DB Analyzer for TYPO3 v13 is also worked on to address collations.
I will close this issue for now, if you feel this is a mistake or have additional feedback, please get in touch. You can also create a follow-up issue.
Could it be you created the tables and switched default collations in your setup at some point? Does it happen on a fresh installation for you too, or an existing project (migrated?)
Does the DB Compare tool show any outstanding changes?