Teradata PT allows use of extended multibyte character sets, such as Japanese, Chinese, Korean, Latin, UTF-8, and UTF-16, as long as they are supported and defined for the database.
The character set must be common among the following elements when using Teradata PT:
- Data
- Session character set, as specified in the job script.
- Character set used to encode the job script.
The exception to the preceding rule is that for UTF-8 and UTF-16, the job script may be coded in one character set while the data is in the other, if the proper setup is executed.
For information about UTF-8 / UTF-16 compatibility and setup, see Options for Specifying UTF-8 and UTF-16 in a Job Script.
For a list of valid values for session character set support, see Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125.
UTF-8 and UTF-16 are only supported by Teradata PT on workstation-attached platforms.