0

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.

Niwa
  • 67
  • 1
  • 5
  • `utf8mb4_0900_as_ci` seems to be the only collation with needed properties combination. See `SHOW COLLATION LIKE '%_as_ci'`. – Akina Feb 27 '22 at 11:57
  • 1
    there a lots of them see https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html everything that ios as and ci should do it – nbk Feb 27 '22 at 12:02
  • @nbk *there a lots of them see ..* A lot? I have provided one collation in the comment above, what is the second one? – Akina Feb 27 '22 at 17:39

1 Answers1

0
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 |
+----------------------------------------------+
Bill Karwin
  • 538,548
  • 86
  • 673
  • 828