Because Common SQL is geared towards ANSI SQL, by default it connects in ANSI mode. If another mode is required, it can be set at connection time.
For example, to make MySQL treat quotes as in ANSI without setting other ANSI features, do:
(sql:connect "me/mypassword/mydb"
:sql-mode "ANSI_QUOTES")
See the description of the
:sql-mode
argument to
connect
in the
LispWorks Reference Manual
for details.