UTF-8 sort bug?

[meralda-art]

Please have a look at the tags of http://esmeralda.eu.org/archives/7-Mera ... lickr.html or http://esmeralda.eu.org/archives/8-MY-W ... VITED.html

I do not understand the sort of the Greek and Cyrillic letters.

e.g:
deutschland, бавария, германия, erfolg
iso 100, βαυαρία, γερμανία, landkreis

Thank you!

[garvinhicking]

Hi!

The ordering is done using the internal MySQL ordering routines. It takes the collation of a table into appreciation, and it seems that UTF-8 ordering is meant that way. You might want to ask MySQL people where that ordering comes from, but Serendipity simply uses what the database offers.

Best regards,
Garvin

[meralda-art]

I don't know very much about MySQL. AFAIR charsets can be defined in each table with MySQL. So doesn't it depend on the default-settings of tables, which were created at setup of s9y?

[garvinhicking]

Hi!

s9y uses utf8_unicode_ci for unicode tables so it uses the default mysql unicode sorting.

Best regards,
Garvin