The following examples show how INDEX(string_1, string_2) operates when the server character set for both arguments is KANJI1 and the client character set is KanjiShift-JIS.
IF string_1 contains … | AND string_2 contains … | THEN the result is … |
---|---|---|
mnABC X | B | 4 |
mnABC X | X | 6 |