Name
*DEFAULT-STRING-LENGTH* — Default length of SQL strings
Variable
Description
If a slot of a class defined by
DEF-VIEW-CLASS is of the type
STRING or VARCHAR and does
not have a length specified, then the value of this variable
is used as SQL length.
Examples
(let ((*default-string-length* 80))
(def-view-class s80 ()
((a :type string)
(b :type (string 80))
(c :type varchar))))
(create-view-from-class 's80)
The above code causes a SQL table to be created with the SQL command
CREATE TABLE (A VARCHAR(80), B CHAR(80), C VARCHAR(80))
Affected By
Some SQL backends do not support VARCHAR
lengths greater than 255 .
Notes
This is a CLSQL extension to the CommonSQL API.