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

Basic Teradata Query Reference

prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

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 for Teradata Database, refer to the Teradata Database documentation.

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