From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Samuel Gendler <sgendler(at)ideasculptor(dot)com> |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Eyal Wilde <eyal(at)impactsoft(dot)co(dot)il>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: a strange order by behavior |
Date: | 2011-06-22 13:44:00 |
Message-ID: | BANLkTikK=9fcF2T=Wnipx_h4fXhFW0GmQQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> 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čka
Crha
Semerád
Syn
Záruba
Šebíšek
(6 rows)
postgres=# select * from x order by a collate "cs_CZ";
a
-----------
Crha
Chromečka
Semerád
Syn
Šebíšek
Záruba
(6 rows)
Regards
Pavel Stehule
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-06-22 14:49:09 | Re: a strange order by behavior |
Previous Message | Samuel Gendler | 2011-06-22 11:20:50 | Re: a strange order by behavior |