#101719Environment Status reports: MySQL database character set check failed
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(?).