Hi, I'm a visual foxpro programmer: -----Original Message----- From: ÅÇ´f¼Ù (Borus.Kung) [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 10:00 To: [EMAIL PROTECTED] Subject: Using multi-byte character set
Hi, I am using double byte character set (big5) under mandrake linux with MySQL everything seemed ok after building the DB and tables after some time of testing I found some characters cannot be inserted, like those characters include the back slash '\'. it was simply disappeared as MySQL treat it as an invalid escape sequence. I can tackle the problem to add another back slash to the string when I am doing sth using C API. e.g. try to insert "1234\po", then I modify the string to "1234\\po" then "1234\po" can be retrieved from DB. But it seemed difficult to do using ODBC since I am using ASP and VB for the front end. So I am searching for a "one time" solution for the problem. Is it necesary for me to add big5 to the character set? but I don't need the to sort any double byte character field. what should I do? thanks for reading Borus -------------------------------------- It require you to convert all string before talking with ODBC in you programming langauge. If you got a better idea, pleae let me know. --------------------------------------------------------------------- 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