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