'MYSQL: best utf setting for ACCENT sensitive but CASE insensitive

For example, ἐν or Ἐν are the same, but should be distinguished from ἕν/Ἓν. I've tried utf8_bin which seems to be the closest, but is also case sensitive.

mysqlcase-insensitivediacriticsutfaccent-sensitive


Solution 1:[1]

mysql> select '??' = '??' collate utf8mb4_0900_as_ci;
+----------------------------------------------+
| '??' = '??' collate utf8mb4_0900_as_ci       |
+----------------------------------------------+
|                                            1 |
+----------------------------------------------+

mysql> select '??' = '??' collate utf8mb4_0900_as_ci;
+----------------------------------------------+
| '??' = '??' collate utf8mb4_0900_as_ci       |
+----------------------------------------------+
|                                            0 |
+----------------------------------------------+

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Bill Karwin

Related Questions