List:General Discussion« Previous MessageNext Message »
From:Moon's Father Date:May 24 2008 6:58am
Subject:Re: mysqldump character set
View as plain text  
If you create all your databases and tables with utf8,then every thing is
fine.

On Mon, Apr 28, 2008 at 1:43 AM, Velen <velen@stripped> wrote:

> Hi,
>
> I'm storing some ascii codes in a table.  When I do a dump using mysqldump
> from the server and then restoring it on another station, the ascii codes in
> the table has changed.
>
> But if i'm accessing the table from another station the code is good.  Even
> if I insert it from a station, it goes fine in the server.
>
> Anyone knows why it changes when using mysqldump?  How can I prevent this
> problem to happen in the future?
>
> Regards,
>
> Velen




-- 
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

Thread
mysqldump character setVelen27 Apr
  • Re: mysqldump character setMoon's Father24 May