Issue Bug Closed

#101719Environment Status reports: MySQL database character set check failed

Timo Gurr 08/21/23, 09:26 updated 07/09/24, 15:19

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(?).

Reviews 3