Re: MySQL non-portable with Oracle, MS-SQL, Sybase SQL statements due to ISO non-conformant backslash

[Ken Johanson]

Thanks!!! Yes, I found the bug on it, but it looks like its not working 
yet.... Is the bug simply no updated to show the fix perhaps?

ken
Sergei Golubchik wrote:
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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]