Skip site navigation (1) Skip section navigation (2)

BUG #1991: UPPER problem on special characters

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Oliver JowettDate: 2005-10-23 21:23:35
Subject: Re: BUG #1988: keygen not implemented
Previous:From: John HansenDate: 2005-10-23 18:17:21
Subject: Re: BUG #1987: UTF8 encoding differences hamper upgrades

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group