*DEFAULT-STRING-LENGTH* — Default length of SQL strings
Variable
Fixnum
255
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.
(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))
Some SQL backends do not support VARCHAR lengths greater than 255 .
None.
This is a CLSQL extension to the CommonSQL API.