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

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

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 Teradata Vantage™ - Advanced SQL Engine 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.