Encoding option
Specifies the type of data in the file. The system supports single-byte characters in Latin9 encoding and Unicode data in multibyte UTF-8 encoding.
Values are as follows:
- 'latin9'
- The entire file contains only Latin9 char or varchar data, no nchar or nvarchar data. If the file contains any nchar or nvarchar data, it is rejected by the load operation.
- 'utf8' or 'utf-8'
- The entire file uses UTF-8 encoding and contains only nchar or nvarchar data, no char or varchar data. If the file contains any char or varchar data, it is rejected by the load operation.
- 'internal'
- The file can contains Latin9 data, UTF-8 data, or both and can use any combination of char, varchar, nchar, or nvarchar data types. Use the 'internal' value if you are not certain of the data encoding. This is the default.
If necessary, use the nzconvert command to convert character encoding before loading data from external tables.
The Encoding option is not supported for the fixed-length format.