17.10 - Example: Using Examples for the KanjiShift-JIS Client Character Set - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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