Dear Monty, At the beginning, I missed doing the step of setting default character-set.
After I have done what you said about setting default character set, the correct chinese characters are stored in mysql database. Thank you very much! Best regards, Henry. >From: Michael Widenius <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: "henry lee" <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Chinese character problem Date: Mon, 24 Jun 2002 14:30:44 +0300 > > >Hi! > > >>>>> "henry" == henry lee <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO >/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland > <___/ www.mysql.com _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
