17.10 - Example: Using the KanjiEUC Client Character Set with the ctable1 Table - 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 the KanjiEUC 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 …
A ss2 B CD SELECT SUBSTR(c1,2) FROM ctable1; ss2 B CD
ss3 A ss2 B ss3 C ss2 D SELECT SUBSTR(c1,2,2) FROM ctable1; ss2 B ss3 C