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

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

pgsql-cygwin by date

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

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