Rules for Chinese and Korean Character Sets | Basic Teradata Query - Rules for Chinese and Korean Character Sets - Basic Teradata Query

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-04-02
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
Product Category
Teradata Tools and Utilities

The following rules exist for Chinese and Korean character sets on both network and mainframe platforms. For information on Chinese and Korean character set restrictions, see International Character Set Support, B035-1125.

SHOW TABLE Command

When you use the SHOW TABLE command, compress and default values that include any characters outside of 7-bit ASCII are shown as Unicode hexadecimal constants. Also, the SHOW TABLE command cannot show a table that has object names with characters outside of 7-bit ASCII.

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.