D. Settings for Strict ANSI Compliance : Connection Flags : -string_truncation Connection Flag
 
Share this page                  
-string_truncation Connection Flag
The -string_truncation connection flag specifies how the DBMS handles attempts to write a character string to a table column that is too short to contain it (in an INSERT, UPDATE, COPY, or CREATE TABLE...AS SELECT statement). For details about this connection flag, see String Truncation (see String Truncation).
ANSI/ISO Entry SQL-92
Specify -string_truncation=fail. If string truncation occurs, the statement that attempted to write the string fails and an error is returned.
Ingres Default
Omit flag or specify -string_truncation=ignore. By default, the string is truncated to fit into the column, the statement succeeds, and no error is returned.