ASA Database Administration Guide
Controls behavior when character data is truncated at the client side.
ON, OFF
OFF
ON for Open Client and JDBC connections
The ANSI_BLANKS option has no effect unless the database was created with the -b command-line option. It forces a truncation error whenever a value of data type CHAR(N) is read into a C char(M) variable for values of N greater than or equal to M. With ANSI_BLANKS set to OFF, a truncation error occurs only when at least one non-blank character is truncated.
For embedded SQL, if ANSI_BLANKS is ON when you supply a value of data type DT_STRING, you must set the sqllen field to the length of the value, including space for the terminating null character. With ANSI_BLANKS off, the length is determined solely by the position of the null character.
The ANSI_BLANKS setting persists for the life of a connection. Changing it after a connection has been established does not affect that connection.
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.