Postgres Pro
Downloads
Home   >   mailing lists

Re: lower('Å') or upper('å') gives imp - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: lower('Å') or upper('å') gives imp
Date
Msg-id Pine.LNX.4.44.0311151934540.5327-100000@peter.localdomain
Whole thread Raw
In response to lower('Å') or upper('å') gives improper results.  ("Neha Kasat" <neha_kasat@infosys.com>)
Responses Re: lower('Å') or upper('å') gives imp  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
Neha Kasat writes:

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

It does if you select the right locale.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-bugs by date:

Previous
From: "Neha Kasat"
Date:
Subject: lower('Å') or upper('å') gives improper results.
Next
From: Tom Lane
Date:
Subject: Re: lower('Å') or upper('å') gives imp