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