15.00 - Character Set Specification - FastLoad

Teradata FastLoad Reference

prodname
FastLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2411-034K

Character Set Specification

Table 10 lists character sets supported by Teradata FastLoad.

 

Table 10: Character Sets Supported by Teradata FastLoad 

Character Set Name

Description

Configuration

ASCII

Latin

Networkattached

EBCDIC

Latin

Mainframeattached

HANGULEBCDIC933_1II

Korean

Mainframeattached

HANGULKSC5601_2R4

Korean

Networkattached

KANJIEUC_0U

Japanese

Networkattached

KANJISJIS_0S

Japanese

Networkattached

KATAKANAEBCDIC

Japanese

Mainframeattached

KANJIEBCDIC5026_0I

Japanese

Mainframeattached

KANJIEBCDIC5035_0I

Japanese

Mainframeattached

SCHEBCDIC935_2lJ

Simplified Chinese

Mainframeattached

SCHGB2312_1T0

Simplified Chinese

Networkattached

TCHEBCDIC937_3IB

Traditional Chinese

Mainframeattached

TCHBIG5_1R0

Traditional Chinese

Networkattached

UTF8

Unicode character set

  • Mainframeattached
  • Networkattached
  • UTF16

    Unicode character set

    Networkattached

    SiteDefined 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.

     

    Table 11: SiteDefined Character Sets 

    Character Set Name

    Description

    Configuration

    SDHANGULEBCDIC933_5II

    Korean

    MainframeAttached

    SDHANGULKSC5601_4R4

    Korean

    NetworkAttached

    SDKATAKANAEBCDIC_4IF

    Japanese

    MainframeAttached

    SDKANJIEBCDIC5026_4IG

    Japanese

    MainframeAttached

    SDKANJIEBCDIC5035_4IH

    Japanese

    MainframeAttached

    SDKANJIEUC_1U3

    Japanese

    NetworkAttached

    SDKANJISJIS_1S3

    Japanese

    NetworkAttached

    SDSCHEBCDIC935_6IJ

    Simplified Chinese

    MainframeAttached

    SDTCHEBCDIC937_7IB

    Traditional Chinese

    MainframeAttached

    SDSCHGB2312_2T0

    Simplified Chinese

    NetworkAttached

    SDTCHBIG5_3R0

    Traditional Chinese

    NetworkAttached

    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
  • Object names are limited to A‑Z, a‑z, 0‑9, and special characters such as $ and _.

  • Maximum String Length
  • 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.