> 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