MYSQL：針對重音敏感但對大小寫不敏感的UTF設定的最佳選擇

Question

例如，ἐν或Ἐν是相同的，但應與ἕν/Ἓν區分開來。我嘗試了utf8_bin，它似乎是最接近的，但也區分大小寫。

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