16.10 - Detecting ASCII and Teradata LATIN Differences - 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

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;