Bug #20867
closedTable sys_refindex / KEY lookup_string not UTF-8 compatible
0%
Description
In t3lib/stddb/tables.sql the key definition was changed from (ref_table(133),ref_string) to (ref_table,ref_string).
This leads to an invalid key for databases running in UTF8 mode. Cause of this is that keys in MySQL are defined on character lengths but the internal limits are counted in bytes. As MySQL is limited to 1000 bytes per Index the above definition causes a Problem since the Index is 1365 Bytes (MySQL 5.x, using 3 Bytes per character) or 1820 bytes (MySQL 6.0 using 4 bytes per character).
This bug shows up in the install tool where the index cannot be updated/created.
Create a MySQL Database in UTF-8 collaction/character_set and run TYPO3 Install tool to create tables
(issue imported from #M11694)
Files
Updated by Morton Jonuschat about 15 years ago
Updated by Andreas Otto † almost 15 years ago
If you have a brand new TYPO3 installation the table sys_refindex cannot be created due to this bug.
Therfore increasing the severity of the bug from minor to major.
Looks like we can have this either working for mysql only or for dbal.