From: | "Guillaume Smet" <guillaume_ml(at)smet(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1991: UPPER problem on special characters |
Date: | 2005-10-23 21:21:43 |
Message-ID: | 20051023212143.E0F8EF0E49@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2005-10-23 21:23:35 | Re: BUG #1988: keygen not implemented |
Previous Message | John Hansen | 2005-10-23 18:17:21 | Re: BUG #1987: UTF8 encoding differences hamper upgrades |