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?