I2E Conversion Exceptions - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

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 .