17.05 - CHARACTER and GRAPHIC Server Character Set Limitations for INSERT Operations - 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)

This table describes the data limits on INSERT operations for various CHARACTER and GRAPHIC server character sets.

Client Character Set Type USING Data Type Maximum Size for USING Data Server Character Set Maximum Column Size for INSERT (Characters)
Single byte CHARACTER 64,000 bytes LATIN 64,000
KANJI1
UNICODE

If the USING data row contains more than 32K logical characters (or more than 64K bytes when mixed single-byte-multibyte strings are involved), the characters that exceed that limit are truncated.

Note that this includes Unicode data in both UTF-8 and UTF-16 sessions.

32,000
KANJISJIS

If the USING data row contains more than 32K logical characters (or more than 64K bytes when mixed single-byte-multibyte strings are involved), the characters that exceed that limit are truncated.

Multibyte CHARACTER 64,000 bytes LATIN

If the USING data row contains more than 32K logical characters (or more than 64K bytes when mixed single-byte-multibyte strings are involved), the system rejects the row. Although a Latin field can be defined as 64K, you cannot insert more than 32K multibyte characters into it because the database uses Unicode internally, and Unicode has a 32K limit. The load utilities are similarly limited.

32,000
KANJI1 64,000
UNICODE

If the USING data row contains more than 32K logical characters (or more than 64K bytes when mixed single-byte-multibyte strings are involved), the characters that exceed that limit are truncated.

Note that this includes Unicode data in both UTF-8 and UTF-16 sessions.

32,000
Multibyte CHARACTER 64,000 bytes KANJISJIS

If the USING data row contains more than 32K logical characters (or more than 64K bytes when mixed single-byte-multibyte strings are involved), the characters that exceed that limit are truncated.

32,000
GRAPHIC 32,000 characters GRAPHIC 32,000
LATIN

If the USING data row contains more than 32K logical characters (or more than 64K bytes when mixed single-byte-multibyte strings are involved), the system rejects the row. Although a Latin field can be defined as 64K, you cannot insert more than 32K multibyte characters into it because the database uses Unicode internally, and Unicode has a 32K limit. The load utilities are similarly limited.

KANJI1
UNICODE

If the USING data row contains more than 32K logical characters (or more than 64K bytes when mixed single-byte-multibyte strings are involved), the characters that exceed that limit are truncated.

Note that this includes Unicode data in both UTF-8 and UTF-16 sessions.

KANJISJIS

If the USING data row contains more than 32K logical characters (or more than 64K bytes when mixed single-byte-multibyte strings are involved), the characters that exceed that limit are truncated.