search

MariaDB / mariadb-docker

Docker Official Image packaging for MariaDB
https://mariadb.org
GNU General Public License v2.0
770 stars 438 forks source link

utf8mb4_0900_ai_ci is missing #388

Closed zigazajc007 closed 3 years ago

zigazajc007 commented 3 years ago

utf8mb4_0900_ai_ci needs to be added and used by default on every database / table like Mysql 8.0 does.

grooverdan commented 3 years ago

That's a rather broad statement. What's your requirement? Migration?

The feature is missing on the server side and requested in https://jira.mariadb.org/browse/MDEV-20912. With enough votes it will probably get implemented.

Why use 0900 when 14.0.0 is available (https://www.unicode.org/Public/UCA/)?

zigazajc007 commented 3 years ago

What's your requirement? Migration?

I only need stable collation. I still don't understand why utf8mb4_general_ci is default as it can act funky and now days processors are good enough to work with utf8mb4_unicode_ci.

I have only make quick research (Not an expert) and found some answers. (StackOverflow)

I still don't understand why MariaDB don't have option for any newer unicode collation.

It seems that MariaDB is still stuck in year 2010.

Why use 0900 when 14.0.0 is available (https://www.unicode.org/Public/UCA/)?

14.0.0 would be better, but as MariaDB is still stuck at 5.2.0 (Year 2010) it would be good if they at least make a small step and update to at least 9.0.0 as MySQL already use that version as default.

grooverdan commented 3 years ago

Looking at the source it looks like a base understanding of UCA and some scripting to get the constants ported will add a collation. You are very welcome to help out.

grooverdan commented 3 years ago

Looking forward to your contribution. Closing because its not a docker library issues.