The following bug has been logged online:

Bug reference: 1991
Logged by: Guillaume Smet
Email address: guillaume_ml (AT) smet (DOT) org
PostgreSQL version: 8.1b3
Operating system: RHEL 3
Description: UPPER problem on special characters
Details:

Hi,

I'm currently testing 8.1b3 to prepare our migration from 7.4 to 8.1.
I have a µ (greek mu) in my database correctly encoded as UTF-8 (database
encoding is UTF-8). A SELECT UPPER() on this character gives me an error:
ERROR: invalid multibyte character for locale but I can display it with a
simple SELECT.
We cannot uppercase this character but I don't think it's an invalid
character. PHP for example just returns µ when I try to strtoupper it.
AFAIK UTF-8 support is stricter in 8.1 but I'm not sure it's the correct
behaviour to return an error in this case.

Thanks for your help.

Regards

--
Guillaume

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org