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(a)gmail.com>
On Wed, Aug 5, 2009 at 19:01, nicolas
goguey<goguey.nicolas(a)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(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l