illegal sort order

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: illegal sort order
Date: 2005-07-12 17:45:37
Message-ID: db0vm6$rj6$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I insalled Postgres 8 in Windows XP with default settings
I xreated database with encoding unicode.

I noticed that the sort order of accented characters is

B

C.

C

this is totally incorrect! It is interesting that names beginning with C
are not contiguous: between C. and C are accented characters.

The correct sort order (by using character code values) shoud be

B
C
C.

How to force the correct sort order or at least move accented characters
to end of sorted list ?

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Patnude 2005-07-12 17:52:24 Temp tables...
Previous Message Douglas McNaught 2005-07-12 17:43:56 Re: Transaction Handling in pl/pgsql