I was not aware that you were running VB.
In perl and PHP we have a function do do this for us.
in perl:
$qtext=$dbh->quote($text);
$dbh->execute("insert into mytable set myvariable = $qtext");
The above quote() function will put a \ in fronnt of all the special
characters listed in the manual.
These in clude "'\ and the hex 00 character.
If the VB library you are using does not have a similar function, you
should write one.
You are welcome.
Dawn Friedland wrote:
>I found a solution!!! ***Replace all backlashes with two backslashes.***
>(The hex value of the backslash is 0x5c, see Joel Rees' previous emails
>for an explanation on how multibyte Japanese characters contain the hex
>value 0x5c and that MySQL uses that value as an escape character.)
>
>VBscript used prior to submitting data to database:
>~~~~~~~~~~~~~~~~~~~~~~~~
>
> szJapaneseText = replace(szJapaneseText, "\","\\")
>
>
>
---------------------------------------------------------------------
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
