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
Updated by Timo Gurr over 1 year ago
- Subject changed from MySQL database character set check failed to Environment Status reports: MySQL database character set check failed
Updated by Gerrit Code Review over 1 year ago
- Status changed from New to Under Review
Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/80632
Updated by Gerrit Code Review over 1 year ago
Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/80632
Updated by Gerrit Code Review over 1 year ago
Patch set 1 for branch 12.4 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/80615
Updated by Gerrit Code Review over 1 year ago
Patch set 1 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/80616
Updated by Timo Gurr over 1 year ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 5a93c81bf4ad0a675c1a970026b8e5b5c0227947.