| From: | "Alex Kostyshin" <root(at)ulif(dot)org(dot)ua> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #2264: bad work with cyrillic encoding |
| Date: | 2006-02-15 15:45:40 |
| Message-ID: | 20060215154540.383E7F0B05@svr2.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2264
Logged by: Alex Kostyshin
Email address: root(at)ulif(dot)org(dot)ua
PostgreSQL version: 8.1.x
Operating system: Windows XP/SP2, Windows XP x64
Description: bad work with cyrillic encoding
Details:
1. Wrong sorting order: not A,a,B,b, etc for cyrillic texts, but
A,B,...,a,b..
String functions do not work with cyrillic arguments, for example:
Latin:
Select lower('Tom')
lower
--------
tom
1 record(s) selected [Fetch MetaData: 31/ms] [Fetch Data: 0/ms]
Cyrillic:
Select lower('')
lower
--------
1 record(s) selected [Fetch MetaData: 0/ms] [Fetch Data: 0/ms]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-02-15 17:07:47 | Re: BUG #2246: Bad malloc interactions: ecpg, openssl |
| Previous Message | bug1 | 2006-02-15 07:14:50 | BUG #2263: corrupted pgstat.stat file |