Data Movement Utilities Guide and Reference

Character Set and NLS Considerations

Unequal code page situations, involving expansion or contraction of the character data, can sometimes occur. For example, Japanese or Traditional-Chinese Extended UNIX Code (EUC) and double-byte character sets (DBCS) may encode different lengths for the same character. Normally, comparison of input data length to target column length is performed before reading in any data. If the input length is greater than the target length, NULLs are inserted into that column if it is nullable. Otherwise, the request is rejected. If the nochecklengths modifier (see File Type Modifiers (Import)) is specified, no initial comparison is performed, and an attempt is made to import the data. If the data is too long after translation is complete, the row is rejected. Otherwise, the data is imported.


[ Top of Page | Previous Page | Next Page ]