16.20 - KanjiEBCDIC 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 KanjiEBCDIC strings using the function (expression LIKE pattern_expression).

expression pattern_expression Server Character Set Result
MN<AB> %<B> KANJI1 TRUE
MN<AB>P <%B>% KANJI1 TRUE
MN<AB>P %P KANJI1 TRUE
MN<AB>P %<__C>% KANJI1 FALSE
__ represents a FULLWIDTH UNDERSCORE.