MYSQL: Best choice for accent-sensitive but case-insensitive UTF settings

Question

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

P粉481815897 · Answer

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 |
+----------------------------------------------+