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

Reply via email to