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

Re: Problem with upper function and special characters

From: mike g <mike(at)thegodshalls(dot)com>
To: Gerardo Castillo <gcastillo(at)ice(dot)co(dot)cr>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: Problem with upper function and special characters
Date: 2004-06-30 03:10:17
Message-ID: 1088565017.16709.8.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-cygwin
Hi,

I don't believe that locale is supported in postgresql.

See http://www.postgresql.org/docs/7.4/static/multibyte.html#AEN18181
for a list of supported character sets.

Double check and make sure that postgres didn't use the default encoding
of Unicode instead.  There is a known bug in 7.4x with Upper/Lower
conversion in Unicode and perhaps that is affecting your encoding as
well.

Mike
On Thu, 2004-06-24 at 12:30, Gerardo Castillo wrote:
> 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.

In response to

pgsql-cygwin by date

Next:From: Felipe SantiagoDate: 2004-06-30 14:16:45
Subject: URGENT: Database Recovery
Previous:From: mike gDate: 2004-06-30 03:04:12
Subject: Re: Question about cygwin/postgres install

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