Re: utf8_croatian_ci - how to make croatian utf8 collation?
Posted by: Neven J
Date: July 03, 2008 03:55PM

Yes, yes. We are going in right direction. :)

This helps only if you want to order by single letter. Eg. you have column with first letter (or two letters in the case of "dž", "lj" and "nj".

Problem which remains is correct ordering of Croatian letters combined with 2 letters: "lj", "nj", "dž" and Croatian letters "š", "đ", "č" and "ć" if words are 4 chars and more. Letter "ž" works in any situation!
eg. "z", "Z", "ž", "Ž" is ok, and "žžžžžžžžžž", "ŽŽŽŽŽŽŽŽŽŽ" is ok.

However, when you do order by now, as I said, it orders correctly small caps and lower caps but only for words with less than 4 letters.
eg: "ććć", "ĆĆĆ" is ok. "ĆĆĆĆ", "ćććć" is not ok.
eg: "ččč", "ČČČ" is ok. "ČČČČ", "čččč" is not ok.
eg: "ššš", "ŠŠŠ" is ok. "ŠŠŠŠ", "šššš" is not ok.


It also orders "lj" and "nj" letters, but only if word has less than 5 chars (4 Croatian letters).

eg. "lj", "LJ" is ok.
eg. "ljab", "LJAB" is ok. but "LJABA", "ljaba" is not ok.
eg. "njab", "NJAB" is ok. but "NJABA", "Njaba" is not ok.


On other hand, ordering of words with letter "dž", doesn't work. "dž", "DŽ" is ok, but "DŽA", and "dža" is not.

Similar with "đ" alone.
eg. "đ", "Đ" is ok. but "ĐĐ", "đđ" is not.
on other hand "đaa", "ĐAA" is ok, but "ĐAAA", "đaaa" is not ok.

Any help is still greatly appreciated, and needed!

Best regards
Neven

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



Edited 1 time(s). Last edit at 07/03/2008 04:04PM by Neven J.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: utf8_croatian_ci - how to make croatian utf8 collation?
7823
July 03, 2008 03:55PM


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.