KanjiEBCDIC Examples

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

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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.