You can specify the encoding to be used by passing the
:encoding
argument to connect. Common SQL supports various encodings for MySQL as documented in connect.
The default is to use the default for the particular MySQL installation.
LispWorks User Guide and Reference Manual - 22 Dec 2009