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

On Sat, May 25, 2002 at 12:56:06AM -0400, Tom Lane wrote:
> 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...

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. Both
are Debian Linux. Perhaps the bug lies in the locale definition supplied by
Debian?

--
Henry House
The attached file is a digital signature. See <http://romana.hajhouse.org/pgp>
for information. My OpenPGP key: <http://romana.hajhouse.org/hajhouse.asc>.