Re: [GENERAL] bug in 7.4.2, concern unicode and russian content of

From: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
To: "Alexander S(dot)" <sasha(at)in(dot)crimea(dot)ua>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: [GENERAL] bug in 7.4.2, concern unicode and russian content of
Date: 2004-06-07 19:58:19
Message-ID: 1086638299.26618.2.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

On Mon, 2004-06-07 at 12:11, Alexander S. wrote:
> 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?

What locale was your database initialized with?

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Christian van der leeden 2004-06-07 20:38:40 Re: A memory leak. Postgres 7.4. Mac OS. X Server
Previous Message PostgreSQL Bugs List 2004-06-07 19:38:57 BUG #1161: User permissions are kept, even if user is dropped

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2004-06-07 20:21:48 Re: [HACKERS] Slony-I goes BETA (possible bug)
Previous Message Peter of the Norse 2004-06-07 19:31:01 Re: Updating a unique constrant