Thread: BUG #2264: bad work with cyrillic encoding

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]