17.10 - Example: Data Returned in ASCII - Advanced SQL Engine - Teradata Database

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

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)

Consider a BTEQ session with the ASCII client character set.

The data from the cunicode, csjis, and clatin columns are returned to the BTEQ session in ASCII, as illustrated by the following figure.

Note that your application should declare its variables as mixed single-byte strings to store the data from the Teradata Database.

Because the ASCII repertoire is much smaller than the repertoires of cunicode or csjis columns, some characters might be converted to error characters on input, some might be converted to something else on export, or the transaction might abort.