SQL Reference Guide > SQL Reference Guide > J. 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.
Actian X Default
Omit flag or specify -string_truncation=warn. By default, the string is truncated to fit into the column, the statement succeeds, and an error is returned.
Last modified date: 08/14/2024