bug in 7.4.2, concern unicode and russian content of db

From: "Alexander S(dot)" <sasha(at)in(dot)crimea(dot)ua>
To: pgsql-general(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: bug in 7.4.2, concern unicode and russian content of db
Date: 2004-06-07 18:11:33
Message-ID: 40C4AFD5.5010508@in.crimea.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

There is bug in 7.4.2, concerning unicode and russian letters. For db
in unicode russian data doesn`t order in alphabetical order (rows group
with the same first letter but not in alphabetical order).
SELECT "person" from my_table ORDER BY "person";
Rows group in such order (approximately): А-Я-В-Т-З, but must be :
А-В-З-Т-Я.
For english letters all looks fine. For db in koi8r encoding also all
works right. So, I CANNOT use unicode with russian content of db in
postgres. Is it bug or not?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL Bugs List 2004-06-07 19:38:57 BUG #1161: User permissions are kept, even if user is dropped
Previous Message Tom Lane 2004-06-07 13:41:53 Re: whitespaces and upper()

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2004-06-07 18:33:58 Re: [HACKERS] Slony-I goes BETA (possible bug)
Previous Message Jeff Boes 2004-06-07 18:08:36 Re: Timestamp precision and rounding