IBM Books

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 have different length encodings 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 (Load)) is specified, no initial comparison is performed, and an attempt is made to load the data. If the data is too long after translation is complete, the row is rejected. Otherwise, the data is loaded.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]