16.20 - Truncation Exceptions and Fixed Length Columns - 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

Fixed length columns are awkward to use in Kanji environments. The reason is that ANSI SQL treats fixed length strings in terms of characters, while most applications treat fixed length strings in terms of physical bytes. The difference cannot be reconciled.

Teradata SQL addresses this problem by treating LATIN, UNICODE and GRAPHIC character data type columns according to ANSI, but also providing the export width rules to export them as fixed byte length fields. For more information about export width, see Working with Export Widths.