16.20 - Example: Using Examples for the KanjiShift-JIS Client Character Set - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

The following table shows examples for KanjiShift-JIS client character set, where ctable1 is the table defined in "Example: Effect of the Order of SELECT Statements on Data Type" in Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .

IF c1 contains … THEN this query … Returns …
mnABC X SELECT SUBSTR(c1, 6, 1) FROM ctable1; X
SELECT SUBSTR(c1,4) FROM ctable1; BC X