Project

General

Profile

Actions

Bug #105540

closed

Mixed charsets in table defaults and text columns

Added by Benjamin Franzke 16 days ago. Updated 10 days ago.

Status:
Resolved
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Start date:
2024-11-05
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
13
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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
    ```


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Task #105574: Account for different utf8 platform aliases in schema migrator assertionsResolved2024-11-12

Actions
Actions #1

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

Actions #2

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

Actions #3

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

Actions #4

Updated by Benjamin Franzke 10 days ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #5

Updated by Benjamin Franzke 9 days ago

  • Related to Task #105574: Account for different utf8 platform aliases in schema migrator assertions added
Actions

Also available in: Atom PDF