I2E Conversion Exceptions - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

For information about Internal-to-External (I2E) conversions and how exceptions are handled in sessions where Unicode Pass Through is enabled, see Exporting from a UNICODE Server Character Set.

I2E conversion generates an exception when a character in the server repertoire cannot be converted to the client repertoire.

For example, an attempt to convert a multibyte KANJISJIS character to an ASCII character generates a conversion exception.

For most I2E character conversion, exceptions are ignored and the offending character is converted to the predefined error character for the target client character set.

For information on error characters, see Error Characters.

Conversion from GRAPHIC

The I2E conversion from GRAPHIC to single-byte characters in any client character set generates an SQL error.

To get the hexadecimal representation for GRAPHIC characters, you can use CHAR2HEXINT .