Thread: UPPER

UPPER

From
"João" Paulo Batistella
Date:
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

Re: UPPER

From
David Delibasic
Date:
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
>


Re: UPPER

From
Thomas Beutin
Date:
Hi,

On Tue, Jul 16, 2002 at 12:01:55PM -0700, João Paulo Batistella wrote:
> 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?
try an "initdb" with the right locale setting ("export LC_ALL=es"
on a bash or whatever Your specific locale is).

-tb
--
Thomas Beutin                             tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.

Re: UPPER

From
"João" Paulo Batistella
Date:
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