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

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

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

Eliminating special string quoting requirements, for non single-quote characters (ANSI/ISO)

2004-12-10 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

Re: Porting Tables Between Windows and Linux Version of MySQL

2004-12-10 Thread Ken Johanson
The only gotcha I'm aware of is that you must set the *nix server to use case-insensitive table names, since on windows the SQL table references didnt need to match case. I'll leave you to you own devices to find that documentation (I just dont have it handy, sorry) select 8 from testtable ||