nicolas goguey wrote: > Sorry but i don't understand. > > I explain : > > I want update my wikipedia to : 1.10.2 to 1.15.2. > > I begin to export my database (i try with mysqldump and with phpmyadmin). > I use php update.php and i import my database but all accent stocked in my > database are like this : > è ---> è > é ---> é > À ---> À > ..... > > And all my page are broken :(. > > I try to use > > UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'è','è'); > UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'é','é'); > UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'À','À'); > UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'î','î'); > UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'â','â'); > UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'à _','à_'); > UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'É','É'); > UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'û','û'); > UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'ê','ê'); > UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'Ã','Ï'); > UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'ç','ç'); > UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'ö','ö'); > UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'ï','ï'); > UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'’','’'); > > for all my tables but i don't know all the change :s and i have lot of page > !
No, no, no. That's wrong! MediaWiki will be storing è as è but that's just because mysql thinks it's in latin1 (whereas it's in fact utf-8). MediaWiki should be showing it right. Do you have $wgDBmysql5 set to false? Also, you could have had problems due to http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki#Character_set _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
