20.9.4 SQL mode

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.

LispWorks User Guide - 11 Mar 2008