TRIM_PARTIAL_MBC option

Function

Allows automatic trimming of partial multibyte character data.

Allowed values

ON, OFF

Default

OFF

Scope

DBA permissions are not required to set this option. Can only be set for the PUBLIC group. Takes effect immediately.

Description

Provides consistent loading of data for collations that contain both single-byte and multibyte characters. When TRIM_PARTIAL_MBC is ON:

When TRIM_PARTIAL_MBC is OFF, normal CONVERSION_ERROR semantics are in effect.

See also

“CONVERSION_ERROR option [TSQL]”.