Variable | Package: dbi | ToC | DocOverview | CGDoc | RelNotes | FAQ | Index | PermutedIndex
| Allegro CL version 10.1 Unrevised from 10.0 to 10.1. 10.0 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-2022, Franz Inc. Lafayette, CA., USA. All rights reserved.
This page was not revised from the 10.0 page.
Created 2019.8.20.

|  | ToC | DocOverview | CGDoc | RelNotes | FAQ | Index | PermutedIndex
| Allegro CL version 10.1 Unrevised from 10.0 to 10.1. 10.0 version