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

From Tom Lane
Subject Re: Bug #676: lower(), upper(), & initcap() do not work on utf-8 chars
Date
Msg-id 2999.1022383504@sss.pgh.pa.us
Whole thread Raw
In response to Bug #676: lower(), upper(), & initcap() do not work on utf-8 chars  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Henry House <hajhouse@houseag.com> writes:
>> Unfortunately you didn't mention anything about your locale setup...

> The server locale is en_US.UTF-8. (At least I set it up as such when
> installing PostgreSQL; I know no way to verify.) The server version is 7.2.=
> 1,
> running on a IA32 and a DEC Alpha; both machines show the same behavior. Bo=
> th
> are Debian Linux. Perhaps the bug lies in the locale definition supplied by
> Debian?

Offhand I'd not necessarily expect an en_US locale to upcase/downcase
anything except a-z/A-Z.  Perhaps you need to use a different locale.

I'd suggest taking this up with a locale expert, which I surely am
not.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #676: lower(), upper(), & initcap() do not work on utf-8 chars
Next
From: Caspar Bothmer
Date:
Subject: bug in documentation