Truncation Exceptions in Teradata Mode - Analytics Database - Teradata Vantage

International Character Set Support

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-09-27
dita:mapPath
aju1628095815656.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
hqj1472245413611
lifecycle
latest
Product Category
Teradata Vantageā„¢

In Teradata mode, truncation can occur without error in many operations, for example:

  • If, during external-to-internal or explicit conversions, the data to be placed in a fixed character column expands so that the column length is exceeded, Vantage truncates on the logical character boundary, and if necessary, pads to the full length of the column. Padding is done with the pad character of the target column type and occurs only on fix columns.
  • If data to be placed in a varying column expands so that the maximum column length is exceeded, Vantage truncates the input on the logical character boundary so that the maximum length of the column is not exceeded.
  • During internal-to-external conversion, a truncation exception can occur due to the limited output length imposed by the defined export width. Those exceptions are ignored as they were in previous releases.
  • Suppose the length designated by the export width is defined to be l. If during internal-to-external conversion data expands so that l is exceeded, then Vantage truncates on the logical character boundary and for fixed characters, pads to length l. Truncation on the logical boundary is with respect to the client form-of-use. Padding is done with the pad character of the client form-of-use.

For an illustration of truncation with padding, see Example: KanjiEUC. For other truncation examples, see Example: KanjiEBCDIC and Example: KanjiSJIS.