Problemi con la conversione UTF8 di mediawiki

Convertire tutto il database in UTF8 (vedi guida MYSQL nel wiki).

Ci sono problemi con degli indici:

Error: 1071, Specified key was too long; max key length is 1000 byte

http://bugs.mysql.com/bug.php?id=6604

Cambiare la struttura in:

DROP TABLE IF EXISTS `rvmwiki_categorylinks`;
CREATE TABLE `rvmwiki_categorylinks` (
  `cl_from` int(8) unsigned NOT NULL default '0',
  `cl_to` varchar(250) character set utf8 collate utf8_bin NOT NULL default '',
  `cl_sortkey` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `cl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
  KEY `cl_sortkey` (`cl_to`,`cl_sortkey`(80)),
  KEY `cl_timestamp` (`cl_to`,`cl_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Mettere:

$wgDBmysql5 = true.

In Localsettings.php

Riferimenti

• http://www.xaprb.com/blog/2006/04/17/max-key-length-in-mysql/