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

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ywb1588027283948.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.