Issue Task Closed

#102667BE Module Reports show"illegal mix of collations" Message

Michael Kasten 12/13/23, 14:42 updated 06/25/24, 14:38

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

  1. Garvin Hicking commented and changed status New Needs Feedback 06/16/24, 19:40

    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?

  2. Benni Mack changed category 06/19/24, 20:56

  3. Garvin Hicking commented and changed status Needs Feedback Closed 06/25/24, 14:38

    The 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.