Unicode Pass Through Functionality | Teradata Vantage - 17.20 - Unicode Pass Through Functionality - 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)
UPT provides the following functionality in Pass Through sessions:
  • Proper storage of all assigned and unassigned Unicode characters from U+0000 to U+10FFFD.
  • Ability to store PTCs in Unicode columns as data and retrieve it as entered. For example:
    INSERT INTO currency (U&'#20BD' UESCAPE '#');
  • Ability to use PTCs in queries. For example:
    SELECT feed FROM twitter WHERE feed LIKE U&'%#+01F602%' UESCAPE '#';
  • Noncharacters and ill-formed code unit sequences are changed to the REPLACEMENT CHARACTER (U+FFFD) which can pass through and be stored in Teradata.

With UPT enabled, users can expect translation errors to be reduced or eliminated.