17.20 - Truncation Exceptions and Fixed Length Columns - Analytics Database - Teradata Vantage

Teradata Vantageā„¢ - Analytics Database International Character Set Support - 17.20

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
2023-01-27
dita:mapPath
aju1628095815656.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
hqj1472245413611

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.