[MDEV-12339] Adding case sensitive utf8 collation to MariaDB Created: 2017-03-23  Updated: 2022-08-25  Resolved: 2022-08-17

Status: Closed
Project: MariaDB Server
Component/s: Character Sets
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Roman Shkola Assignee: Alexander Barkov
Resolution: Duplicate Votes: 6
Labels: Compatibility, Migration, Oracle, collation, utf8

Issue Links:
Duplicate
duplicates MDEV-27009 Add UCA-14.0.0 collations Closed

 Description   

Hello,
I would like to ask you to add a case sensitive utf8 collation, e.g. utf8_general_cs or something like that. Please, let me know how long will it take to implement this extension.
Thanks!
P.S. In process of migration from Oracle DBMS to MariaDB, we found out that MariaDB is lacking unicode case sensitive collations.

 Comments   
Comment by Jonathan Davies [ 2017-11-06 ]

It appears that this is being addressed in MySQL - see here. Is there an update on when this may be addressed in MariaDB?

Comment by Lance Fogle [ 2020-03-04 ]

Since this is already resolved after MySQL 8.0.1, this should not be that hard to port into MariaDB I wouldn't think. This is several years old and still hasn't been done though MariaDB is supposed to be a "drop-in replacement for MySQL" and this would be a very key feature in modern databases.

Is there any plan on the roadmap at all to bring this in from MySQL codebase?

Comment by Alexander Barkov [ 2022-08-17 ]

Case sensitive collations were added to MariaDB-10.10 under terms of MDEV-27009.

Generated at Thu Feb 08 07:56:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.