17.10 - Limitations - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)

Storage space for this server character set is allocated on a byte basis rather than a character basis. This means that updates to a column defined as KANJISJIS can truncate because of this physical space.

SQL string manipulations of KANJISJIS data operate on a logical character basis and are performed by means of temporary conversion to Unicode. For this reason, KANJISJIS strings are limited to 32000 characters.