The following examples show how INDEX(string_1, string_2) operates when the server character set for string_1 and the server character set for string_2 differ. In these cases, both arguments are converted to UNICODE (if needed) and the characters are matched logically.
| IF string_1 is … | AND string_2 is … | THEN the result is … | ||
|---|---|---|---|---|
| Character Set | Data | Character Set | Data | |
| UNICODE | 92 abc |
LATIN | abc | 4 |
| UNICODE | abc | UNICODE | c | 3 |
| KANJISJIS | 92 04 |
UNICODE | 0 | 4 |