Re: UPPER

Hi.

I set LC_ALL to pt_BR and re- initdb to recreate de
database. But the sql statement select upper('jo�o')
still returns JO�O.
Is there any other step to make this work?

Thanks,
JP

--- David Delibasic <maddave@suxx.eu.org> wrote:
> 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
> >
>


__________________________________________________
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com