[MDEV-24768] Feature request: a collation that is case insensitive but otherwise treats all characters as distinct Created: 2021-02-02 Updated: 2021-12-10 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Hartmut Holzgraefe | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Description |
|
Basically the same as my experimental "utf8-general-ci" proof of concept, but as part of the server, and well tested. https://mariadb.com/resources/blog/adding-a-case-insensitive-distinct-unicode-collation/ (e.g. AFAIR mine did still treat 'ß' as the same as 'ss' which it actually shouldn't) |
| Comments |
| Comment by Hartmut Holzgraefe [ 2021-02-02 ] |
|
See also: https://bugs.mysql.com/bug.php?id=19567 |
| Comment by Hartmut Holzgraefe [ 2021-02-02 ] |
|
See also utf8mb4_0900_as_ci in MySQL 8.0.x, which should actually provide exactly that as far as I understand their new collation naming scheme ... |