Variable | Package: dbi | ToC | DocOverview | CGDoc | RelNotes | FAQ | Index | PermutedIndex
| Allegro CL version 9.0 Unrevised from 8.2 to 9.0. 8.2 version

## *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.

|  | ToC | DocOverview | CGDoc | RelNotes | FAQ | Index | PermutedIndex
| Allegro CL version 9.0 Unrevised from 8.2 to 9.0. 8.2 version