17.10 - Detecting ASCII and Teradata LATIN Differences - Advanced SQL Engine - Teradata Database

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

You can detect code points that conflict with ASCII semantics either before or after migrating to Teradata LATIN. Corrective action can then be taken under either environment.

SELECT cchar
FROM tab1
WHERE
INDEX(cchar, '80'XC) <> 0
OR INDEX(cchar, '81'XC) <> 0
OR INDEX(cchar, '82'XC) <> 0
.
/* all codes 83-FE */
.
OR INDEX(cchar, 'FF'XC) <> 0;