Re: Problem with upper function and special characters

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.