SQL Reference Guide > SQL Reference Guide > D. Settings for Strict ANSI Compliance > Connection Flags > -string_truncation Connection Flag
Was this helpful?
-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 on page 97.
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.
Last modified date: 01/30/2023