$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(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l