Hello,
I'm writing a project that involves entering chinese character into
MySQL database.
Since 1) connection-based coding selection requires an upgrade to
version 4.1.1 or above and my company don't want to do that, 2) the web
program will run in both big5 and gb2312 so I can't simply set the coding to
big5, and 3) my company's backend is written in VB6.0 which is they told me
do not support unicode(so I can't change the database's default coding to
Unicode), I have to seek method to deal with it in the coding.
For most of the time, it is OK to have the coding be latin1, which is
the default character coding for MySQL. However, when the lower byte of the
character is " ' "
or " " " the SQL server will mixup the data and the keywords in the SQL
statement, which would not be the case if I set proper character coding for
the SQL.
I've tried to use String.Replace() to replace " ' " with " \' " but
seems that the function won't recognize it at all.(This is normal as while
the program is running it's running in Unicode) Could anyone suggest other
ways to deal with it?
Thanks alot.
Regards,
Lau Lei Cheong
--
If you want to mail to me, please replace all instance of "e" to "a" in my
email address. Thank you.
Sorry for any inconvience caused, but I there's many spam-mailers.
