illegal sort order - Mailing list pgsql-general

From Andrus
Subject illegal sort order
Date
Msg-id db0vm6$rj6$1@news.hub.org
Whole thread Raw
Responses Re: illegal sort order
List 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.




pgsql-general by date:

Previous
From: "Greg Patnude"
Date:
Subject: Temp tables...
Next
From: Douglas McNaught
Date:
Subject: Re: Transaction Handling in pl/pgsql