Actions
Bug #20867
closedTable sys_refindex / KEY lookup_string not UTF-8 compatible
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2009-08-12
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
4.3
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:
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
Actions