区分重音但不区分大小写的最佳 UTF 设置

Question

例如，ἐν或Ἐν是相同的，但应与ἕν/Ἓν区分开来。我尝试过 utf8_bin ，它似乎是最接近的，但也区分大小写。

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