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

expression pattern_expression Server Character Set ANSI Mode Result Teradata Mode Result
ABCD __B% GRAPHIC TRUE TRUE
mnABCI %B% UNICODE TRUE TRUE
mnABCI %I UNICODE TRUE TRUE
mnABCI mn_%I KANJI1 TRUE

The underscore in pattern_expression matches a single byte- or multibyte character in ANSI mode.

FALSE

The underscore in pattern_expression matches a single byte character in Teradata mode.

mnABCI mn__%I KANJI1 TRUE TRUE
__ represents a FULLWIDTH UNDERSCORE.
_ represents a SPACING UNDERSCORE.