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	June 29, 2004 19:18:42
Msg-id	0HZT00H13PTCGT@ice.co.cr Whole thread Raw
Responses	Re: Problem with upper function and special characters (mike g <mike@thegodshalls.com>)
List	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.

From: s.j.adair@att.net
Date: 29 June 2004, 19:00:55
Subject: Question about cygwin/postgres install

From: mike g
Date: 30 June 2004, 03:08:07
Subject: Re: Question about cygwin/postgres install