Hi.
Have a look at http://www.mysql.com/doc/E/x/Extensions_to_ANSI.html
(rather at the end). || has a different meaning in MySQL started
without explicit --ansi. Also see
http://www.mysql.com/doc/A/N/ANSI_mode.html.
Bye,
Benjamin.
On Mon, Apr 08, 2002 at 11:08:15AM -0400, [EMAIL PROTECTED] wrote:
> Hi guys,
>
> Our java code blows up when we try to insert a string with a ';'
> inside of it. So we tried to do a work-around by replacing ';' with
> '||CHAR(59)||' to insert it, using the char function and the
> character's respecitve ascii value. So instead of:
[...]
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
