16.20 - KanjiShift-JIS 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 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.