#9 Quoting

[Anonymous]

In the queries the quoting of values uses the lax mysql
syntax of " (aka double quotes), this is all well and good for
a standard installation. However, if the server is running in
ANSI mode (or just has ANSI_QUOTE sql_mode on) then
pretty much nothing works.

All queries with quotes around values should be changed to
single quotes (').

Right off the bat the with the SHOW VARIABLES LIKE
"version" fails and should be SHOW VARIABLES LIKE 'version'
and then about a handful more of the queries in the setting
and the WHEREing.

I really like the CocoaMySQL, but some other recent
products we are using with our database are forcing us to
turn on the ANSI_QUOTING mode.

In the interim I have downloaded the source and made the
changes to the queries/quoting and have compiled a version
for myself, but it would be nice to see it rolled into the
mainstream version.