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