Aran Dunkley escribió: > $wgDBmysql5 is set to false, the show create table for page gives this > on both the original and the new server: > > mwiki_page | CREATE TABLE `mwiki_page` ( > `page_id` int(8) unsigned NOT NULL AUTO_INCREMENT, > `page_namespace` int(11) NOT NULL DEFAULT '0', > `page_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, > `page_restrictions` tinyblob NOT NULL, > `page_counter` bigint(20) unsigned NOT NULL DEFAULT '0', > `page_is_redirect` tinyint(1) unsigned NOT NULL DEFAULT '0', > `page_is_new` tinyint(1) unsigned NOT NULL DEFAULT '0', > `page_random` double unsigned NOT NULL DEFAULT '0', > `page_touched` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT > NULL DEFAULT '', > `page_latest` int(8) unsigned NOT NULL DEFAULT '0', > `page_len` int(8) unsigned NOT NULL DEFAULT '0', > PRIMARY KEY (`page_id`), > UNIQUE KEY `name_title` (`page_namespace`,`page_title`), > KEY `page_random` (`page_random`), > KEY `page_len` (`page_len`) > ) ENGINE=MyISAM AUTO_INCREMENT=19105 DEFAULT CHARSET=latin1 > COLLATE=latin1_spanish_ci
Your table has latin1 charset, but page_title has it as utf-8. Since page_touched will contain the same in latin1 as utf-8, you could fix this changing $wgDBmysql5 to true, but given this inconsistence, that might break displaying of content from other tables :/ _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
