Your string contains special characters, and must be properly escaped before storing. Use the appropriate string escaping function in your language ( if it exists ) or write a routine to escape them for you before storing them. The manual lists the special characters.
henry lee wrote: > Dear professional people, > > When I write a program to store the (Big5) Chinese characters 特許經營 > into mysql database through the mysql ODBC driver, > the original chinese characters change into another characters 特雩g營 > in mysql database. > > On the other hand, I have tried the program to store the (Big5) Chinese > characters into another database through another ODBC driver, it is > correct. > The chinese characters remain the same. > --------------------------------------------------------------------- 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