16.20 - KanjiEUC Examples - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

The following examples indicate the behavior of LIKE with KanjiEUC strings using the function (expression LIKE pattern_expression).

expression pattern_expression Server Character Set Result
ss3A ss2B ss3C ss2D % ss2B% UNICODE TRUE
M ss2B N ss2D M __% GRAPHIC TRUE
ss3A ss2B ss3C ss2D __% KANJISJIS TRUE
ss3A ss2B ss3C ss2D _ % KANJISJIS TRUE
__ represents a FULLWIDTH UNDERSCORE.
_ represents a SPACING UNDERSCORE.