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