16.20 - Limitations - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K

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.