Character Set Specification
Table 10 lists character sets supported by Teradata FastLoad.
Character Set Name |
Description |
Configuration |
ASCII |
Latin |
Network‑attached |
EBCDIC |
Latin |
Mainframe‑attached |
HANGULEBCDIC933_1II |
Korean |
Mainframe‑attached |
HANGULKSC5601_2R4 |
Korean |
Network‑attached |
KANJIEUC_0U |
Japanese |
Network‑attached |
KANJISJIS_0S |
Japanese |
Network‑attached |
KATAKANAEBCDIC |
Japanese |
Mainframe‑attached |
KANJIEBCDIC5026_0I |
Japanese |
Mainframe‑attached |
KANJIEBCDIC5035_0I |
Japanese |
Mainframe‑attached |
SCHEBCDIC935_2lJ |
Simplified Chinese |
Mainframe‑attached |
SCHGB2312_1T0 |
Simplified Chinese |
Network‑attached |
TCHEBCDIC937_3IB |
Traditional Chinese |
Mainframe‑attached |
TCHBIG5_1R0 |
Traditional Chinese |
Network‑attached |
UTF‑8 |
Unicode character set |
|
UTF‑16 |
Unicode character set |
Network‑attached |
Site‑Defined Character Sets
When the character sets defined are not appropriate for a site, custom character sets can be defined using the information in Table 11. For information on defining a custom character set, see SQL Data Definition Language (B035‑1144).
Table 11 lists the site‑defined character sets.
Character Set Name |
Description |
Configuration |
SDHANGULEBCDIC933_5II |
Korean |
Mainframe‑Attached |
SDHANGULKSC5601_4R4 |
Korean |
Network‑Attached |
SDKATAKANAEBCDIC_4IF |
Japanese |
Mainframe‑Attached |
SDKANJIEBCDIC5026_4IG |
Japanese |
Mainframe‑Attached |
SDKANJIEBCDIC5035_4IH |
Japanese |
Mainframe‑Attached |
SDKANJIEUC_1U3 |
Japanese |
Network‑Attached |
SDKANJISJIS_1S3 |
Japanese |
Network‑Attached |
SDSCHEBCDIC935_6IJ |
Simplified Chinese |
Mainframe‑Attached |
SDTCHEBCDIC937_7IB |
Traditional Chinese |
Mainframe‑Attached |
SDSCHGB2312_2T0 |
Simplified Chinese |
Network‑Attached |
SDTCHBIG5_3R0 |
Traditional Chinese |
Network‑Attached |
Note: For information on defining a custom character set, see International Character Set Support (B035‑1132).
Rules for Chinese and Korean Character Set Use
Follow these rules when using Chinese and Korean character sets on mainframe‑attached and network‑attached platforms.
Object names are limited to A‑Z, a‑z, 0‑9, and special characters such as $ and _.
The DBS requires two bytes to process each of the Chinese or Korean characters. This limits both request size and record size. For example, if a record consists of one string, the length of that string is limited to a maximum of 32,000 characters or 64,000 bytes.
For more information about Chinese or Korean character set restrictions for the Teradata Database, refer to International Character Set Support (B035‑1132).
AXSMOD
When an AXSMOD is used, Teradata FastLoad will pass the session character set as an attribute to the AXSMOD for its possible use (most AXSMODs will not make any use of this information).
The attribute value will be a variable length character string consisting of the character set name; the attribute name will be CHARSET_NAME.