Author: lqs

Description:
I'm trying to install MediaWiki 1.4.3 on my computer. I use PHP 5.0.4 and MySQL
4.1.11. I want my MediaWiki supporting Unicode.

When I was installing MediaWiki, there was an error:

Creating tables...Query "CREATE TABLE categorylinks ( cl_from int(8) unsigned NOT
NULL default '0', cl_to varchar(255) binary NOT NULL default '', cl_sortkey varchar
(255) binary NOT NULL default '', cl_timestamp timestamp NOT NULL, UNIQUE KEY cl_from
(cl_from,cl_to), KEY cl_sortkey(cl_to,cl_sortkey(128)), KEY cl_timestamp
(cl_to,cl_timestamp) )" failed with error code "Specified key was too long; max key
length is 1024 bytes".

This happens if I created the database with utf8 charset. There's no error when i
recreate the datebase with Latin1 or GBK(Chinese) charset, but there will be no
Unicode support.

What can I do to install MediaWiki with Unicode support?

Version: 1.4.x
Severity: blocker
OS: Windows XP
Platform: PC