Postgres Pro
Downloads
Home   >   mailing lists

Problem with upper function and special characters - Mailing list pgsql-cygwin

From Gerardo Castillo
Subject Problem with upper function and special characters
Date
Msg-id 0HZT00H13PTCGT@ice.co.cr
Whole thread Raw
Responses Re: Problem with upper function and special characters
List pgsql-cygwin
Tree view
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.

pgsql-cygwin by date:

Previous
From: s.j.adair@att.net
Date:
Subject: Question about cygwin/postgres install
Next
From: mike g
Date:
Subject: Re: Question about cygwin/postgres install