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

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #676: lower(), upper(), & initcap() do not work on utf-8 chars
Date: 2002-05-25 04:23:51
Message-ID: 20020525042351.927C7475A77@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Henry House (hajhouse(at)houseag(dot)com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
lower(), upper(), & initcap() do not work on utf-8 chars

Long Description
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.

Sample Code
SELECT upper('');

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-05-25 04:56:06 Re: Bug #676: lower(), upper(), & initcap() do not work on utf-8 chars
Previous Message Jeff Post 2002-05-25 00:16:28 views are not auto completed on psql