Re: lower('Å') or upper('å') gives imp

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Neha Kasat <neha_kasat(at)infosys(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: lower('Å') or upper('å') gives imp
Date: 2003-11-15 19:08:29
Message-ID: 20761.1068923309@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> 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.

... and character set. We don't have support for this yet in multibyte
character sets (like Unicode). You need to pick an appropriate ISOnnnn
encoding and a suitable locale setting.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Theodore Petrosky 2003-11-16 01:25:57 Re: RC2 will not make check on OSX 10.3
Previous Message Peter Eisentraut 2003-11-15 18:35:09 Re: lower('Å') or upper('å') gives imp