*auto-trim-strings*

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-2019, Franz Inc. Oakland, CA., USA. All rights reserved.
This page was not revised from the 8.2 page.
Created 2012.5.30.