$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
Platonides wrote:
Aran Dunkley escribió:
Hi I'm wondering if anyone can help with this multibyte character corruption: http://aqes.organicdesign.tv/Categor%C3%ADa:Arquitecto
The site was moved from a shared host to a dedicated server, but now it's not rendering the multibyte characters properly in the titles, but seems ok in the content. The mediawiki version went from 1.15.1 to 1.15.3 and the MySQL version 5.1.30 to 5.1.45 and all the configuration seems identical on the new server.
I've tried all the tips about --default-character-set to latin1 or utf8 etc mentioned in the MW manual page but nothing seems to change it no matter what I use for export or import.
A solution would be greatly appreciated as their site has been down for almost a week now while trying to solve this.
Thanks, Aran
What do you have $wgDBmysql5 set to? What's the output of doing SHOW CREATE TABLE page; ?
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l