Re: UPPER - Mailing list pgsql-general

From David Delibasic
Subject Re: UPPER
Date
Msg-id 20020716234455.T35748-100000@spider.suxx.eu.org
Whole thread Raw
In response to UPPER  ("João" Paulo Batistella <batistellabr@yahoo.com.br>)
Responses Re: UPPER
List pgsql-general
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
>


pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: Question: merit / feasibility of compressing frontend
Next
From: Thomas Beutin
Date:
Subject: Re: UPPER