Skip site navigation (1) Skip section navigation (2)

BUG #2264: bad work with cyrillic encoding

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 (view raw or flat)
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]

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-02-15 17:07:47
Subject: Re: BUG #2246: Bad malloc interactions: ecpg, openssl
Previous:From: bug1Date: 2006-02-15 07:14:50
Subject: BUG #2263: corrupted pgstat.stat file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group