16.10 - Example: Data Returned in ASCII - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

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.