-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.
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.