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 !
Please help me.
Thank you.
2009/8/5 Kalan kalan.001@gmail.com
On Wed, Aug 5, 2009 at 19:01, nicolas gogueygoguey.nicolas@gmail.com wrote:
I have a new problème. my conversion of charactere is really bad for
example
é for é
MediaWiki works with bytes, not characters. It doesn’t care about the encoding your SQL server stores bytes in, so should you.
— Kalan
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l