Hi!
On Dec 16, Ken Johanson wrote:
> Hi all,
>
> Does anyone know fo a way to run the server in more of a string-quoting
> standards compliant mode, so that a generic SQL string quoting function
> only has to escape single quotes, instead of also '"', '\', and '\0'?
>
> I've tried the ANSI_QUOTES startup option, but that apparently only
> changes the treatment of double quotes, and requiring single quotes for
> strings... '\' for example still needs a non-standard treatment.
>
> What I'd like to be able to do is have \",\\,\0 characters treated as
> any other so that statements become portable.
MySQL 5.0
NO_BACKSLASH_ESCAPES sql mode.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
