17.20 - Types of Exceptions - Advanced SQL Engine - Teradata Database

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

Advanced SQL Engine
Teradata Database
Release Number
June 2022
Last Update
Content Type
User Guide
Publication ID
English (United States)

Conversion of character data type between a client form-of-use and the Vantage form-of-use may encounter exception situations.

There are three possible exceptions.

Type Description See
Illegal client data form-of-use An illegal form-of-use occurs when the client data violates the structure of the client form-of-use, for example, an unmatched SI character in KanjiEBCDIC. Illegal Form-of-Use
Conversion exception A conversion exception occurs when there is no character in the target repertoire that corresponds to a character from the source string.
Truncation exception A truncation exception occurs when the source cannot fit into the target field without truncation of a non-pad character. Truncation Exceptions

For information on how exceptions are handled in sessions where Unicode Pass Through is enabled, see Unicode Pass Through.