The database allows a character set to be established when invoking FastExport. For example, if a table or database names that have Kanji double-byte characters or mixed single-byte and multibyte characters, the appropriate character set can be chosen.
The following table lists the standard character sets supported by FastExport.
| Name | Description | System Configuration |
|---|---|---|
| EBCDIC | Latin | Mainframe-attached |
| ASCII | Latin | Workstation-attached |
| HANGULEBCDIC933_1II | Korean | Mainframe-attached |
| HANGULKSC5601_2R4 | Korean | Workstation-attached |
| KATAKANAEBCDIC | Japanese | Mainframe-attached |
| KANJIEBCDIC5026_0I | Japanese | Mainframe-attached |
| KANJIEBCDIC5035_0I | Japanese | Mainframe-attached |
| KANJIEUC_0U | Japanese | Workstation-attached |
| KANJISJIS_0S | Japanese | Workstation-attached |
| SCHEBCDIC935_2lJ | Simplified Chinese | Mainframe-attached |
| SCHGB2312_1T0 | Simplified Chinese | Workstation-attached |
| TCHBIG5_1R0 | Traditional Chinese | Workstation-attached |
| TCHEBCDIC937_3IB | Traditional Chinese | Mainframe-attached |
| UTF8 | Unicode® character set | Workstation-attached |
| UTF-8 | Unicode character set | Mainframe-attached Workstation-attached |
| UTF16 | Unicode character set | Workstation-attached |
| UTF-16 | Unicode character set | Workstation-attached |
Site-Defined Character Sets
When the character sets defined are not appropriate for a site, define the character sets shown in the following table.
| Name | Description | System Configuration |
|---|---|---|
| SDKATAKANAEBCDIC_4IF | Site-defined Japanese | Mainframe-attached |
| SDKANJIEBCDIC5026_4IG | Site-defined Japanese | Mainframe-attached |
| SDKANJIEBCDIC5035_4IH | Site-defined Japanese | Mainframe-attached |
| SDKANJIEUC_1U3 | Site-defined Japanese | Workstation-attached |
| SDKANJISJIS_1S3 | Site-defined Japanese | Workstation-attached |
| SDSCHEBCDIC935_6IJ | Site-defined Simplified Chinese | Mainframe-attached |
| SDTCHEBCDIC937_7IB | Site-defined Traditional Chinese | Mainframe-attached |
| SDSCHGB2312_2T0 | Site-defined Simplified Chinese | Workstation-attached |
| SDTCHBIG5_3R0 | Site-defined Traditional Chinese | Workstation-attached |
| SDHANGULEBCDIC933_5II | Site-defined Korean | Mainframe-attached |
| SDHANGULKSC5601_4R4 | Site-defined Korean | Workstation-attached |
Rules for Using Chinese and Korean Character Sets
- Object Names
Object names are limited to A-Z, a-z, 0-9, and special characters such as $ and _.
- Maximum String Length
The database 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, or for more information about alternate character sets, see Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125.
If Japanese language support is not required, specify EBCDIC or ASCII as the character set parameter.