Partial multibyte LONG VARCHAR data is truncated during the load according to the value of the TRIM_PARTIAL_MBC database option.
The table "Partial multibyte character on loading LONG VARCHAR with ASCII FILE option" lists how a trailing multibyte character is loaded, depending on the values of TRIM_PARTIAL_MBC and SECONDARY_FILE_ERROR.
| TRIM_PARTIAL_MBC | SECONDARY_FILE_ERROR | Trailing Partial Multibyte Character Found |
|---|---|---|
| ON | ON/OFF | Trailing partial multibyte character truncated |
| OFF | ON | Cell — null, if null allowed LOAD error — roll back, if null not allowed |
| OFF | OFF | Cell — null, if null allowed Cell — zero-length, if null not allowed |