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