Feature request/proposition: Croatian utf8 collation (utf8_croatian_ci)

[Neven J]

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.