SQL Reference Guide > SQL Reference Guide > SQL Statements > SET > STRING_TRUNCATION
Was this helpful?
STRING_TRUNCATION
SET STRING_TRUNCATION IGNORE|FAIL|WARN statement changes the current error handling setting (see Specify Error Handling for String Truncation) for string truncation.
The default setting is WARN, which truncates and inserts the string and issues a warning. For example, it notifies you when truncation occurs when unloading or reloading a database using unloaddb or copydb. This can be especially useful if you are migrating to UTF8 using the -nvarchar flag.
Valid values are:
IGNORE
Truncates and inserts the string without issuing a message.
WARN
(Default) Truncates and inserts the string and issues a warning.
Note:  The Vectorwise warning message for X100 operation does not show the number of truncated records.
FAIL
Aborts the statement and issues an error.
Last modified date: 08/14/2024