Re: Next: Encoding Issue

In the shell environment

export LC_ALL=C

This will often fix many locale ills.

>-----Original Message-----
>From: pdxpug-owner(at)postgresql(dot)org
>[mailto:pdxpug-owner(at)postgresql(dot)org] On Behalf Of Rich Shepard
>Sent: Monday, February 02, 2009 7:04 PM
>To: pdxpug(at)postgresql(dot)org
>Subject: [pdxpug] Next: Encoding Issue
>
> I'm seeing this error when I try to create a database
>within TinyERP:
>
>createdb: database creation failed: ERROR: encoding UTF8 does
>not match
>server's locale en_US
>DETAIL: The server's LC_CTYPE setting requires encoding LATIN1.
>
> The application is designed for unicode (that's UTF8, isn't
>it?) and I
>cannot pass the '-E' option to the createdb command within the
>application.
>Please suggest approaches to resolve this conflict.
>
>Thanks,
>
>Rich
>
>--
>Richard B. Shepard, Ph.D. | Integrity
> Credibility
>Applied Ecosystem Services, Inc. | Innovation
><http://www.appl-ecosys.com> Voice: 503-667-4517 Fax:
>503-667-8863
>
>--
>Sent via pdxpug mailing list (pdxpug(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pdxpug
>