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 <[EMAIL PROTECTED]> 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