Re: UPPER

Hi.

Try with setting LC_ALL variable for pgsql user to your locale and
re-`initdb`. I'm using sl_SI.ISO8859-2 for Slovenian language and it works
fine. If you can't find suitable locale you can create or modify one (man
`mklocale`).

btw: Don't forget to `pg_dump` before `initdb` :)

Best Regards,
D.

On Tue, 16 Jul 2002, Jo�o Paulo Batistella wrote:

> Hi.
>
> I�am having problems using the UPPER function.
>
> See the example:
>
> UPPER('jo�o') = JO�O
>
> I thinks this occurs because an accented character
> (�). How can I fix this?
>
> Thanks,
> JP
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Autos - Get free new car price quotes
> http://autos.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>