bug in 7.4.2, concern unicode and russian content of db

[Alexander S.]

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?

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Scott Marlowe]

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?
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Scott Marlowe]

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?
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org