MySQL Forums
Forum List  »  General

Feature request/proposition: Croatian utf8 collation (utf8_croatian_ci)
Posted by: Neven J
Date: April 28, 2009 05:53AM

Hi MySQL community,

Googling for "mysql feature request" doesn't yield many results, so I am not sure if there is a more direct way how to propose/request a feature.

The feature in hand is Croatian utf8 collation based on Croatian alphabet (http://en.wikipedia.org/wiki/Gajica). Without it, MySQL server can't be considered choice for eg. government migration to open-source platform in near future. AFAIK the countries which would benefit from the same implementation (alongside Croatia) are: Bosnia, Serbia (for latin charset) and Monte Negro (for latin charset).

There already is built in latin2 Croatian collation (latin2_croatian_ci) and CP1250 Croatian collation (cp1250_croatian_ci) in MySQL but those implementations lack digraph support - single letters consisted of two letters (http://www.collation-charts.org/mysql60/mysql604.latin2_croatian_ci.html).

Closest to Croatian is Slovenian collation (utf8_slovenian_ci) support built-in in MySQL, but it also lacks digraphs so it's not possible to adapt it (http://www.collation-charts.org/mysql60/mysql604.utf8_slovenian_ci.html).

What does it take to implement Croatian utf8 collation? It takes modifying source code beyond our knowledge. We tried to implement it on our own (with Vietnamese as a base for digraph support), but without much luck. We got stuck at creating digraphs as a pair of basic latin letter + accented Latin letter. And without proper support for those, we will never be able to sort things right (a-b-c-č-ć-d-dž-đ-...i-j-k-l-lj-m-n-nj-...u-v-z-ž)

I posted this topic a year ago and it kind of passed unnoticed: http://forums.mysql.com/read.php?103,192187,216993

Any help would be greatly appreciated by thousands of MySQL developers in our region who are now forced to use hacks from '90 to get correct sort order. :)

Thank you in advance!

Best regards
Neven

--
seven | the witchdoctor
http://www.nivas.hr - uploading 24/7!



Edited 6 time(s). Last edit at 04/28/2009 09:26AM by Neven J.

Options: ReplyQuote


Subject
Written By
Posted
Feature request/proposition: Croatian utf8 collation (utf8_croatian_ci)
April 28, 2009 05:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.