[BUGS] =?iso-8859-1?Q?lower=28=27=C5=27=29_or_upper=28=27=E5=27=29_gives_imp?= =?iso-8859-1?Q?roper_results=2E?=

[Neha Kasat]

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-versa when using upper.

Neha

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org