17.10 - KanjiEUC Examples - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
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.