The following examples indicate the behavior of LIKE with KanjiEUC strings using the function (expression LIKE pattern_expression).
| expression | pattern_expression | Server Character Set | Result |
|---|---|---|---|
| ss3A ss2B ss3C ss2D | % ss2B% | UNICODE | TRUE |
| M ss2B N ss2D | M __% | GRAPHIC | TRUE |
| ss3A ss2B ss3C ss2D | __% | KANJISJIS | TRUE |
| ss3A ss2B ss3C ss2D | _ % | KANJISJIS | TRUE |
| __ represents a FULLWIDTH UNDERSCORE. | |||
| _ represents a SPACING UNDERSCORE. | |||