*auto-trim-strings*

variable, dbi package

This variable controls whether blanks are trimmed from the right side of string values returned by sql select calls. The default is t. Blanks are typically added when you insert in the database a string containing fewer characters than are specified for the location. Suppose, for example, a column has a type char(6) and your string is "foo". You may get back "foo" (i.e. with three added blanks).

Sometimes, however, you may want to see the full string including the blanks, in which case you can set this variable to nil. But note that some databases always trim strings in this way before passing them to the AODBC interface. In such cases setting *auto-trim-strings* to nil will have no effect.

See aodbc.html for more information on Allegro ODBC.

*default-database*

variable, dbi package

The value of this variable should be nil or a database object such as returned by connect. If the value is a database object, it will be used as the default for various DBI functions that take a database object as an argument, such as sql.

See aodbc.html for more information on Allegro ODBC.

*default-odbc-external-format*

variable, dbi package

The value of this variable is the default external format to be used for database connections. Initially the value is the external format returned by evaluating the form (crlf-base-ef :latin1). See crlf-base-ef.

See aodbc.html for more information on Allegro ODBC.

*null-value*

variable, dbi package

This variable is used to represent null values in a row of values returned by a database access (such rows can contain null values). When these null values are to be returned to a Lisp program by Allegro ODBC, it represents them by the value in this variable. The initial value for *null-value* is nil.

See aodbc.html for more information on Allegro ODBC.

Copyright (c) 2023, Franz Inc. Lafayette, CA., USA. All rights reserved.