Bug #105540
closedMixed charsets in table defaults and text columns
100%
Description
After upgrading from latin1 to utf8 via Update Wizard (it set's utf8 and not utf8mb4!)
and applying
$GLOBALS['TYPO3_CONF_VARS']['DB']['Connections']['Default']['defaultTableOptions'] = [ 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', ];
Tables ended up in mixed scenarios where the columns used the desired charset options, but the table defaults were still defined to use the older charset and collation.
``` CREATE TABLE `sys_note` ( `uid` int(10) unsigned NOT NULL AUTO_INCREMENT, `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ```
Updated by Gerrit Code Review 16 days ago
- Status changed from New to Under Review
Patch set 3 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/+/86880
Updated by Gerrit Code Review 14 days ago
Patch set 4 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/+/86880
Updated by Gerrit Code Review 10 days ago
Patch set 1 for branch 13.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/+/86933
Updated by Benjamin Franzke 10 days ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 6745243edaf7a7535da25f5bddddf6021900fd4c.
Updated by Benjamin Franzke 9 days ago
- Related to Task #105574: Account for different utf8 platform aliases in schema migrator assertions added