Re: Bug #676: lower(), upper(), & initcap() do not work on utf-8 chars

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: hajhouse(at)houseag(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #676: lower(), upper(), & initcap() do not work on utf-8 chars
Date: 2002-05-25 04:56:06
Message-ID: 23560.1022302566@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> The string case manipulation functions lower(), upper(), & initcap()
> have no effect on non-ASCII characters in the argument, such as , ,
> , , etc. ASCII chars in the argument are properly up- or down-cased.
> The database encoding is UTF-8.

lower/upper-casing is driven by locale, not encoding.

Unfortunately you didn't mention anything about your locale setup...

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Henry House 2002-05-25 22:06:46 Re: Bug #676: lower(), upper(), & initcap() do not work on utf-8 chars
Previous Message pgsql-bugs 2002-05-25 04:23:51 Bug #676: lower(), upper(), & initcap() do not work on utf-8 chars