Hi!
On Dec 17, Sergei Golubchik wrote:
> 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.
I see, you found it yourself already :)
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]
