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. | ||||