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

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

Conversion of character data type between a client form-of-use and the Teradata Database 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.