Supported Character Sets - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide - 20.00

Deployment

VantageCloud

VantageCore

Edition

VMware

Enterprise

IntelliFlex

Lake

Product

Teradata Preprocessor2

Release Number

20.00

Published

October 2023

ft:locale

en-US

ft:lastEdition

2023-11-20

dita:mapPath

nyr1691484085721.ditamap

dita:ditavalPath

obe1474387269547.ditaval

dita:id

xfi1470440464166

Product Category

Teradata Tools and Utilities

There is support for Chinese and Korean character sets. UTF-16 support is available on Microsoft Windows, UNIX, and mainframe system environments.

When Teradata-defined character sets are not appropriate for the site, create site-defined character sets. See the following tables for details.

See Teradata Vantage™ - SQL Fundamentals, B035-1141 to learn about international character sets, character set restrictions, export rules, and defining your own character sets.

Teradata-Defined Character Sets for Mainframe Environments

Character Set Name	Character Set Code Number	Description
EBCDIC	192	Uppercase and lowercase English characters Special characters
HANGULEBCDIC933_1II	108	Korean characters Uppercase and lowercase English characters Multibyte characters Special characters
KATAKANAEBCDIC	111	Uppercase English characters katakana characters Special characters Not supported for the C preprocessor.
KANJIEBCDIC5026_0I	112	Uppercase and lowercase English characters katakana characters Multibyte characters Special characters Not supported with the C preprocessor.
KANJIEBCDIC5035_0I	113	Uppercase and lowercase English characters katakana characters Multibyte characters Special characters
SCHEBCDIC935_21J	109	Simplified Chinese characters Uppercase and lowercase English characters Multibyte characters Special characters
TCHEBCDIC937_3IB	110	Traditional Chinese characters Uppercase and lowercase English characters Multibyte characters Special characters
UTF8	191	Compressed UNICODE (1-3 byte on Teradata)
UTF16	190	2 byte UTF-16

Site-Defined Character Sets for Mainframe Environments

Character Set Name	Character Set Code Number	Language
SDKATAKANAEBCDIC_4IF	77	Japanese
SDKANJIEBCDIC5026_4IG	78	Japanese
SDKANJIEBCDIC5035_4IH	79	Japanese
SDSCHEBCDIC935_6IJ	75	Simplified Chinese
SDTCHEBDIC937_7IB	76	Traditional Chinese
SDHANGULEBCDIC933_5II	74	Korean

Teradata-Defined Character Sets for Workstation-Attached Environments

Character Set Name	Character Set Code Number	Description
ASCII	255	Uppercase and lowercase English characters Special characters
JISCII8	115 (Intel based platforms) 243 (non-Intel based platforms)	Uppercase and lowercase English characters katakana characters Multibyte characters Special characters
HANGULKSC5601_2R4	120	Uppercase and lowercase English characters Multibyte characters Special characters
KANJISJIS_0S	119 (Intel-based platforms) 247 (non-Intel-based platforms)	The SHIFT+JIS character set used by PC clients running DOS/V. It includes: Uppercase and lowercase English characters katakana characters multibyte characters Special characters
KANJIEUC_0U	118 (Intel-based platforms) 246 (non-Intel-based platforms)	The Extended UNIX Code multibyte character set combined with the ASCII character set for single byte characters. It includes: Uppercase and lowercase English characters katakana characters Multibyte characters Special characters
SCHGB2312_1T0	108	Simplified Chinese characters Uppercase and lowercase English characters Multibyte characters Special characters
TCHBIG5_1R0	122	Traditional Chinese characters Uppercase and lowercase English characters Multibyte characters Special characters
UTF8	63	Intel-based platforms
UTF8	191	non-Intel-based platforms
UTF16	62	Intel-based platforms
UTF16	190	non-Intel-based platforms

Site-Defined Character Sets for Workstation-Attached Environments

Character Set Name	Character Set Code Number	Description
SDKANJIEUC_1U3	91	Japanese
SDKANJISJIS_1S3	92	Japanese
SDTCHGB2312_2T0	94	Simplified Chinese
SDTCHBIG5_3R0	95	Traditional Chinese
SDHANGULKSC5601_4R4	93	Korean