Bug #14284 utf8 collation needed for language independent case insensitivity
Submitted: 25 Oct 2005 8:09 Modified: 18 Jan 2018 13:04
Reporter: Domas Mituzas Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Charsets Severity:S4 (Feature request)
Version:4.1,5.0 OS:Linux (Linux)
Assigned to: Assigned Account CPU Architecture:Any
Tags: bfsm_2007_03_15

[25 Oct 2005 8:09] Domas Mituzas
There are no multilanguage collations which would support case insensitivity. Though, there're various exceptions in case handling, a generic collation would do for most cases. 

Collation, that would not contract characters into latin base forms would be needed. 

How to repeat:
'Š'='S' in many collations
'Ö'='O' in many other collations as well.

Suggested fix:
A collation that does not contract characters into base latin/other forms, just applies generic case sensitivity rules.
[18 Jan 2018 13:04] Erlend Dahl
[26 Dec 2017 1:12] Xing Z Zhang

Fixed in 8.0.1 by the case sensitive collations, utf8mb4_lang_0900_as_cs.