| Allegro CL version 8.2 Unrevised from 8.1 to 8.2. 8.1 version |
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.htm for more information on Allegro ODBC.
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.
| Allegro CL version 8.2 Unrevised from 8.1 to 8.2. 8.1 version |