Character Set Specification - FastLoad

Teradata FastLoad Reference

Product
FastLoad
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-18
dita:mapPath
tjz1488824663315.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following table lists character sets supported by Teradata FastLoad.

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
  • Mainframe-attached
  • Network-attached
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 the following table. For information on defining a custom character set, see SQL Data Definition Language (B035-1144).

The following table lists the site-defined character sets.

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

For information on defining a custom character set, see International Character Set Support (B035-1125).

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-1125).

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.