We use MySQL database for pretty much everything now days. It’s de-facto standard for horizontally scaled web sites and it’s used by biggest players in the industry. But one thing that is lacking, and which is very important for our regional market is proper Croatian collation support for utf8 charsets. Without it, MySQL server can’t be considered choice for eg. government migration to open-source platform in near future.<\/p>\n
We tried implementing it on our own for couple of times<\/a>, but without any luck. The problem lies in fact that Croatian language (Serbian and Bosnian too) have digraph<\/a> characters (single characters consisted of two characters – lj, nj and d\u017e). And without proper support for those, we will never be able to sort things right (a-b-c-\u010d-\u0107-d-d\u017e-\u0111-…i-j-k-l-lj-m-n-nj-…u-v-z-\u017e) <\/p>\n What does it take to implement Croatian utf8 collation? It takes modifying source code beyond our knowledge (we tried creating new collation with Vietnamese as a base for digraphs as a pair of basic latin letter + accented Latin letter).<\/p>\n AFAIK the countries which would benefit from the same implementation (alongside Croatia) are: Bosnia, Serbia (for latin charset) and Monte Negro (for latin charset). So please, if you can – spread the word! I think that support for this would be appreciated by thousands of MySQL developers in our region who are now forced to use hacks from ’90 to get correct sort order. :) <\/p>\n I’ve submitted S4 feature request to MySQL – http:\/\/bugs.mysql.com\/44523<\/a> and We use MySQL database for pretty much everything now days. It’s de-facto standard for horizontally scaled web sites and it’s used by biggest players in the industry. But one thing that is lacking, and which is very important for our regional market is proper Croatian collation support for utf8 charsets. Without it, MySQL server can’t…<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1,3],"tags":[],"_links":{"self":[{"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/posts\/1101"}],"collection":[{"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/comments?post=1101"}],"version-history":[{"count":14,"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/posts\/1101\/revisions"}],"predecessor-version":[{"id":1123,"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/posts\/1101\/revisions\/1123"}],"wp:attachment":[{"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/media?parent=1101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/categories?post=1101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/tags?post=1101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nI’ve posted a feature request\/proposition on official MySQL dev forum<\/a>, so we will see what happens. It certainly wouldn’t harm if you would sign in to bugs.mysql.com and MySQL dev forum and reply to my feature request and topic with “Yes please” or something similar. It’s free, and it can make difference. :)<\/p>\n","protected":false},"excerpt":{"rendered":"