ASA Database Administration Guide
  Database Options
    Alphabetical list of options

STRING_RTRUNCATION option [compatibility]

Function 

Determines whether an error is raised when an INSERT or UPDATE truncates a CHAR or VARCHAR string.

Allowed values 

ON, OFF

Default 

OFF

Description 

If the truncated characters consist only of spaces, no exception is raised. The setting of ON corresponds to ANSI/ISO SQL/92 behavior. When it is set to OFF, the exception is not raised and the character string is silently truncated.