Bug #101719
closedEnvironment Status reports: MySQL database character set check failed
100%
Description
After upgrading MariaDB of an existing installation currently at TYPO3 LTS 11.5.30 from MariaDB 10.5.21 to MariaDB 10.11.4 the TYPO3 Environment Status now reports:
MySQL database character set check failed Checking database character set failed, got key "utf8mb3" instead of "utf8 or utf8mb4"
https://get.typo3.org/version/11#system-requirements lists MariaDB >= 10.2.7 <= 10.11.99
According to
https://mariadb.com/kb/en/unicode/
https://stackoverflow.com/questions/63414060/is-utf8-in-mariadb-still-utf8mb3
utf8 is an alias for utf8mb3 on MariaDB >= 10.6 and until MariaDB 10.5 utf8mb3 was an alias for utf8. From MariaDB 10.6, utf8 is by default an alias for utf8mb3 - if I got things right.
So for example phpMyAdmin shows the following collation for the TYPO3 database:
before upgrade: MariaDB 10.5.21 - utf8_general_ci
after upgrade: MariaDB 10.11.4 - utf8mb3_general_ci
TYPO3 11.5.30 currently probably only checks for the strings "utf8" and "utf8mb4" and thus complains about "utf8mb3" not knowing it's actually still plain "utf8" on MariaDB 10.11.4(?).
Files