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
