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-2009, Franz Inc. Oakland, CA., USA. All rights reserved.
Documentation for Allegro CL version 8.1. This page was not revised from the 8.0 page.
Created 2009.7.29.