Last modified: 2011-05-15 10:13:52 UTC
Running MySQL 5.051a-24 configured for utf8 on a Debian Linux box. Mediawiki 1.16alpha r58426.
Get the following error on loading codereview.sql:
ERROR 1071 (42000) at line 79: Specified key was too long; max key length is 1000 bytes
The culprit is:
unique key (ca_user_text, ca_repo_id, ca_author); in table code_authors
which appears to be too long for my utf8 installation.
Tested the table without the key and the extension will run with broken functionality.
By removing it in initial import and then adding it alternatively in phpmyadmin with collate latin1_bin and utf8_bin i can confirm that utf8 encoding breaks the unique key.
Cf bug 9350 and bug 4445