Postgres Pro
Downloads
Home   >   mailing lists

BUG #2264: bad work with cyrillic encoding - Mailing list pgsql-bugs

From Alex Kostyshin
Subject BUG #2264: bad work with cyrillic encoding
Date
Msg-id 20060215154540.383E7F0B05@svr2.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      2264
Logged by:          Alex Kostyshin
Email address:      root@ulif.org.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]

pgsql-bugs by date:

Previous
From: Andrew Klosterman
Date:
Subject: Re: BUG #2246: Bad malloc interactions: ecpg, openssl
Next
From: ""
Date:
Subject: BUG #2263: corrupted pgstat.stat file