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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Felipe Santiago | 2004-06-30 14:16:45 | URGENT: Database Recovery |
Previous Message | mike g | 2004-06-30 03:04:12 | Re: Question about cygwin/postgres install |