Problem with upper function and special characters

From: Gerardo Castillo <gcastillo(at)ice(dot)co(dot)cr>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Problem with upper function and special characters
Date: 2004-06-24 17:30:40
Message-ID: 0HZT00H13PTCGT@ice.co.cr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

Hello,
I have postgresql-7.4.3-1 in windows xp professional sp1 and cygwin.
Postgresql was installed with "--locale=es_ES". parameter

My problem is with the upper function. When I use it with special
characters like áéí, it doesn't convert the case properly.

Ej:
select upper('a');
result is: A (OK)
but ,
select upper('á');
result is: á (It should be Á)

I'd really appreciate any help.

Thanks,
Gerardo.

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Frank Seesink 2004-06-25 03:06:44 Re: troubles after updating from 7.4.2 to 7.4.3
Previous Message s.j.adair 2004-06-24 15:20:08 Question about cygwin/postgres install