17.05 - Non-GRAPHIC Character Data Representation - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

Non-GRAPHIC CHARACTER(n) and VARCHAR(n) data types in a USING request modifier are defined in terms of bytes, where the maximum value of n is 64K.

In all other SQL declarations, such as a column definition within a CREATE TABLE statement, non-GRAPHIC CHARACTER(n) and VARCHAR(n) data types are defined as follows:

This server character set… Is defined in terms of … And the maximum value of n is …
Latin characters 64K
Unicode 32K
Kanji1 [Deprecated] bytes 64K
Kanjisjis 32K
KANJI1 support is deprecated. KANJI1 is not allowed as a default character set. The system changes the KANJI1 default character set to the UNICODE character set. Creation of new KANJI1 objects is highly restricted. Although many KANJI1 queries and applications may continue to operate, sites using KANJI1 should convert to another character set as soon as possible.

For details on the process of importing character data with a USING request modifier, see Character Data Import Process.