Determines whether an error is raised when an INSERT or UPDATE truncates a CHAR or VARCHAR string.
On, Off
On
If the truncated characters consist only of spaces, no exception is raised. The setting of On corresponds to ANSI/ISO SQL/2003 behavior. When this option is set to Off, the exception is not raised and the character string is silently truncated.