Re: UPPER

Hi.

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

Thanks,
JP

--- David Delibasic <maddave(at)suxx(dot)eu(dot)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, Joo Paulo Batistella wrote:
>
> > Hi.
> >
> > Iam having problems using the UPPER function.
> >
> > See the example:
> >
> > UPPER('joo') = JOO
> >
> > 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