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 --------------------------------------------------------------------- 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