17.00 - 17.05 - KanjiEUC Examples - Advanced SQL Engine - Teradata Database

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-30
dita:mapPath
tpt1555966086716.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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.