| From: | David Delibasic <maddave(at)suxx(dot)eu(dot)org> |
|---|---|
| To: | Joo Paulo Batistella <batistellabr(at)yahoo(dot)com(dot)br> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: UPPER |
| Date: | 2002-07-16 21:48:53 |
| Message-ID: | 20020716234455.T35748-100000@spider.suxx.eu.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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, 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johnson, Shaunn | 2002-07-16 21:52:14 | replicating database |
| Previous Message | Thomas Beutin | 2002-07-16 21:43:41 | Re: UPPER |