In most cases, all the elements of a job must use a common character set:
- Data
- Session character set, as specified in the job script
- Character set used to encode the job script
However, because of the unique properties of the Unicode character sets supported by Teradata PT on workstation-attached platforms (UTF-8 and UTF-16), it is possible for the session character set and the job script encoding to use either the same or different Unicode character sets.
Specify the correct Unicode character set in a job script according to the following scenarios:
| Job Script Encoding | Session Character Set | Character Set Specification |
|---|---|---|
| UTF8 | UTF-8 | Specify the character set in the job script as follows:USING CHARACTER SET UTF8 DEFINE JOB… |
| UTF8 | UTF-16 | Specify the character set in the job script as follows:USING CHARACTER SET UTF16 DEFINE JOB… |
| UTF16 | UTF-8 | Do both of the following:
|
| UTF16 | UTF-16 | Do both of the following:
|
Only workation-attached clients running Teradata PT support the use of UTF-8 and UTF-16 character sets in job scripts. Mainframe-attached clients running Teradata PT do not support these character sets.