mysql-escape-sequence

Arguments: seq

seq should be a string or a vector of type (unsigned-byte 8). This function takes seq and returns a string with all of the special characters that mysql's parsers cares about escaped.

If you want to insert a random string or a binary array in a field you'll want to use this function, as in the following example:

(sql (format nil "insert into footab values('~a')"
             (mysql-escape-sequence object)))

See mysql.htm for information on the Allegro MySQL facility.

Copyright (c) 1998-2016, Franz Inc. Oakland, CA., USA. All rights reserved.
This page was not revised from the 8.1 page.
Created 2010.1.21.