When data is loaded to a table that contains a column for which a character set has been defined (character set-defined column), the character encoding of the input data is converted into the character encoding specified for the column. Whether character encoding is to be converted depends on the combination of the input data file format and the table that is the subject to data loading. The table below shows whether character encoding conversion is performed.
Table 5-1 Whether character encoding conversion is performed
Format of input data file | Whether the table subject to data loading contains a character set-defined column | |||
---|---|---|---|---|
Yes | No | |||
DAT format | Y | N | ||
Binary format | N#1 | |||
Fixed-size data format | Y | |||
File output by pdrorg | DAT format | Y | ||
Binary format | Unload file for pdload#3 | Y | ||
Unload file for pdrorg#3 | Y#2 | |||
Table transfer unload file#3 | Y |
pdload does not perform character encoding conversion when you perform data loading to a table that contains a character set-defined column in a binary-format input data file created by the user. Therefore, you must handle conversion of the data in the input data file into the character encoding of the character set-defined column. The table below shows the character encoding used when input data files are created.
Table 5-2 Character encoding used when input data files are created
Input data file format | Whether the table subject to data loading contains a character set-defined column | |
---|---|---|
Yes | No | |
DAT format | Default character set | Default character set |
Binary format | Character encoding specified for the column | |
Fixed-size data format | Default character set |