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.




---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to