Allows automatic trimming of partial multibyte character data.
Scope
Option can be set at the database (PUBLIC) level
only.
Requires the SET ANY SYSTEM OPTION system
privilege to set this option. Takes effect
immediately.
Remarks
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.