UPPER

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.

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 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