SQL Reference Guide > SQL Reference Guide > H. 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.
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=warn. By default, the string is truncated to fit into the column, the statement succeeds, and no error is returned.
Last modified date: 08/28/2024