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

2004-12-17 Thread Ken Johanson
Tried the build 5.0.2-alpha-nt: select 'te\''st' returns "te''t" and select 'te\'''st' causes a fast server crash: -ken (the function symbols are missing so a stacktrace is a bit hard) Application exception occurred: App: (pid=1188) When: 12/17/2004 @ 09:07:05.253 Exception

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

2004-12-17 Thread 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

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

2004-12-17 Thread Sergei Golubchik
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 '

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

2004-12-17 Thread Sergei Golubchik
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_QUO

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

2004-12-16 Thread Ken Johanson
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 chang