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 KanjiEUC.
IF string_1 contains … | AND string_2 contains … | THEN the result is … |
---|---|---|
a b ss3 A | ss3 A | 3 |
a b ss2 B | ss2 B | 3 |
CS1_DATA | A | 6 |
a b ss2 D ss3 E ss2 F | ss2 F | 5 |
a b C ss2 D ss3 E ss2 F | ss2 F | 6 |
CS1_D mATA | A | 7 |