Chinese character problem - Michael Widenius - com.mysql.lists.bugs

2 messages in com.mysql.lists.bugsChinese character problem

From	Sent On	Attachments
henry lee	24 Jun 2002 00:38
Michael Widenius	24 Jun 2002 04:30

Subject:	Chinese character problem
From:	Michael Widenius (mon...@mysql.com)
Date:	06/24/2002 04:30:22 AM
List:	com.mysql.lists.bugs

Hi!

"henry" == henry lee <henr...@hotmail.com> writes:

henry> Dear professional people, henry> When I write a program to store the (Big5) Chinese characters ¯S³\¸gÀç henry> into mysql database through the mysql ODBC driver, henry> the original chinese characters change into another characters ¯S³¸gÀç henry> in mysql database.

What command did you use for storing data ?

If you did this with an INSERT SQL statement, you have to escape the \ ESCAPE character.

This should however work if you are using prepared statements, as in this case the MyODBC driver will handle the escaping of your data.

Have you started the mysqld server with --default-character-set=big5 ?

Regards, Monty