Project

General

Profile

Actions

Bug #20867

closed

Table sys_refindex / KEY lookup_string not UTF-8 compatible

Added by Morton Jonuschat over 15 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Should have
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

11694.diff (389 Bytes) 11694.diff Administrator Admin, 2009-10-14 16:33

Related issues 5 (0 open5 closed)

Related to TYPO3 Core - Bug #20386: Table sys_refindex cannot be created with DBALClosedMichael Stucki2009-05-03

Actions
Related to TYPO3 Core - Bug #19557: db can't create sys_refindex tableClosedMichael Stucki2008-11-03

Actions
Related to TYPO3 Core - Bug #18781: field tablename in sys_refindex too shortClosedRupert Germann2008-05-14

Actions
Has duplicate TYPO3 Core - Bug #20988: Alter table "sys_refindex" is not possible if database is utf8ClosedRupert Germann2009-09-03

Actions
Has duplicate TYPO3 Core - Bug #21100: Update sys_registry - wrong sqlClosedChristian Kuhn2009-09-19

Actions
Actions

Also available in: Atom PDF