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
• Status: Closed
• 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

Description:
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.