17.20 - Detecting ASCII and Teradata LATIN Differences - Analytics Database - Teradata Vantage

Teradata Vantageā„¢ - Analytics Database International Character Set Support - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aju1628095815656.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
hqj1472245413611

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;