[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-bugs
Subject:    Chinese character problem
From:       Michael Widenius <monty () mysql ! com>
Date:       2002-06-24 11:30:44
[Download RAW message or body]


Hi!

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

henry> Dear professional people,
henry>    When I write a program to store the (Big5) Chinese characters 特許經營
henry> into mysql database through the mysql ODBC driver,
henry> the original chinese characters change into another characters 特雩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

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Michael Widenius <monty@mysql.com>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
       <___/   www.mysql.com



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail bugs-thread12138@lists.mysql.com
To unsubscribe, e-mail <bugs-unsubscribe@lists.mysql.com>

[prev in list] [next in list] [prev in thread] [next in thread]