![TSQL_VARIABLES option [TSQL]](arrow-right.gif){kind=icon}
Allows automatic trimming of partial multibyte character data.
ON, OFF
OFF
DBA permissions are not required to set this option. Can only be set for the PUBLIC group. Takes effect immediately.
Provides consistent loading of data for collations that contain both single-byte and multibyte characters. When TRIM_PARTIAL_MBC is ON:
A partial multibyte character is replaced with a blank when loading into a CHAR column.
A partial multibyte character is truncated when loading into a VARCHAR column.
When TRIM_PARTIAL_MBC is OFF, normal CONVERSION_ERROR semantics are in effect.
