Page 1 of 1

UTF-8 sort bug?

Posted: Sat Apr 28, 2007 11:03 pm
by 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!

Re: UTF-8 sort bug?

Posted: Sun Apr 29, 2007 1:17 pm
by 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

Posted: Sun Apr 29, 2007 1:33 pm
by 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?

Posted: Sun Apr 29, 2007 1:37 pm
by garvinhicking
Hi!

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

Best regards,
Garvin