On 12/08/2013 11:34 PM, Nikos Platis wrote:
Here is the correct order of greek characters (mixed case) as produced by
LibreOffice Calc:
α Α ά Ά β Β γ Γ δ Δ ε Ε έ Έ ζ Ζ η Η ή Ή θ Θ ι Ι ί Ί ϊ Ϊ ΐ κ Κ λ Λ μ Μ ν Ν ξ
Ξ ο Ο ό Ό π Π ρ Ρ σ Σ τ Τ υ Υ ύ Ύ ϋΫ ΰ φ Φ χ Χ ψ Ψ ω Ω ώ Ώ
Upper case letters are sorter right after the respective lower case ones,
and, most importantly, accented vowels are sorted right after the
non-accented ones.
Nikos, you could try nunicode, it won't order lower-upper-lower-upper,
but it should be able to correctly handle accents. How it works is
explained in this section:
https://bitbucket.org/alekseyt/nunicode#markdown-header-strings-collation-and-case-mapping
When i finish with Unicode tailoring (localization extension), you
should be able to implement correct collation for Greek characters.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
