On Sat, May 25, 2002 at 12:56:06AM -0400, Tom Lane wrote: > [EMAIL PROTECTED] 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>.
msg04246/pgp00000.pgp
Description: PGP signature
