Re: a strange order by behavior

> I'm actually surprised that european users aren't complaining about this all
> the time, but maybe european users are used to seeing things ordered in a
> manner which doesn't honour the 'correct' ordering of accented characters.
>  Actually, I wonder if the probable explanation of the lack of complaint is
> the fact that the kinds of fields most apps would tend to do alphabetical
> sorts on probably don't tend to have lots of punctuation other than spaces,
> so perhaps the language sensitive sorts are deemed sufficient because most
> people don't notice the funky behaviour with punctuation and whitespace
> while case-insensitive sort is probably desired most of the time.

I checked czech UTF8 collation and it is correct

postgres=# select * from x order by a collate ucs_basic;    a
-----------ChromečkaCrhaSemerádSynZárubaŠebíšek
(6 rows)

postgres=# select * from x order by a collate "cs_CZ";    a
-----------CrhaChromečkaSemerádSynŠebíšekZáruba
(6 rows)

Regards

Pavel Stehule