| From: | "Alexander S(dot)" <sasha(at)in(dot)crimea(dot)ua> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org |
| Subject: | bug in 7.4.2, concern unicode and russian content of db |
| Date: | 2004-06-07 18:11:33 |
| Message-ID: | 40C4AFD5.5010508@in.crimea.ua |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PostgreSQL Bugs List | 2004-06-07 19:38:57 | BUG #1161: User permissions are kept, even if user is dropped |
| Previous Message | Tom Lane | 2004-06-07 13:41:53 | Re: whitespaces and upper() |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2004-06-07 18:33:58 | Re: [HACKERS] Slony-I goes BETA (possible bug) |
| Previous Message | Jeff Boes | 2004-06-07 18:08:36 | Re: Timestamp precision and rounding |