Postgres Pro
Downloads
Home   >   mailing lists

lower('Å') or upper('å') gives improper results. - Mailing list pgsql-bugs

From Neha Kasat
Subject lower('Å') or upper('å') gives improper results.
Date
Msg-id 7727B4DFC8F2D41183E700B0D049D4BC072B8E22@bhumsg02.ad.infosys.com
Whole thread Raw
Responses Re: lower('Å') or upper('å') gives imp  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
Tree view 
Hi,

Please find the output of the simple query :

sfa_db=> select upper('å');
 upper 
-------
 å
(1 row)

PostGRESql doesn't convert the special characters like Å, Ò, etc into their lower case when using function lower and
vice-versawhen using upper. 

Neha

pgsql-bugs by date:

Previous
From: Wolfgang Drotschmann
Date:
Subject: Re: Failure in "make check" with 7.4RC2
Next
From: Peter Eisentraut
Date:
Subject: Re: lower('Å') or upper('å') gives imp