$Revision: 1.1.2.2 $
Package: DBI
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 sring 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 dbi::*auto-trim-strings* to nil will have no effect.
This symbol is associated with the Allegro CL ODBC (AODBC) interface, version 2. Version 2 is new in Allegro CL 5.0.1. It is incompatible with the earlier version 1. Not all customers will have Allegro ODBC version 2. Contact your Franz Inc. sales representative for more information.
Allegro ODBC version 2 is described in aodbc_v2.htm.
The general documentation description is in introduction.htm. The index in index.htm.
Copyright (C) 1998-1999, Franz Inc., Berkeley, CA. All Rights Reserved.