Non-GRAPHIC Character Data Representation - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™

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.