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.