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 |