Re: [Mediawiki-l] Unknown column 'img_sha1' in 'field list'

Thu, 06 Aug 2009 00:52:52 -0700 

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 <[email protected]>

> On Wed, Aug 5, 2009 at 19:01, nicolas goguey<[email protected]>
> 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
> [email protected]
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>
_______________________________________________
MediaWiki-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Reply via email to