TYPO3列出了由于COLLATE而在数据库中进行比较的所有表 [英] TYPO3 lists all tables in DB compare because of COLLATE

问题描述

我正在使用TYPO3 8.7.4和PHP 7.0.22和MariaDB 10.2.7.

I'm using TYPO3 8.7.4 with PHP 7.0.22 and MariaDB 10.2.7.

InstallTool中的数据库比较显示TYPO3想要更改所有表，因为当前值与表的排序规则所期望的不同:

The DB Compare inside the InstallTool shows me that TYPO3 wants to alter all tables because the current value differs from the expected by the collation of the table:

ALTER TABLE `be_groups` CHANGE `title` `title` VARCHAR(50) DEFAULT '' NOT NULL 
Current value: title VARCHAR(50) DEFAULT '''' NOT NULL COLLATE utf8_general_ci

推荐答案

MariaDB对Information Schema COLUMNS表进行了更改，该表与原始" MySQL的预期输出不向后兼容:

MariaDB implemented a change to the Information Schema COLUMNS table which is not backwards compatible with the output expected from the 'original' MySQL:

https://jira.mariadb.org/browse/MDEV-13132

这篇关于TYPO3列出了由于COLLATE而在数据库中进行比较的所有表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！