Re: Overriding local encoding defaults - Mailing list pgsql-novice

Bob McConnell <rmcconne@lightlink.com> writes:
> I am trying to create a Pg 8.4 cluster with UTF8 encoding for JDBC
> access. But initdb insists that because my local console is en_US, it
> cannot do that. We're talking about setting up a server here. Why should
> it even care what the local console settings are?

You need a locale setting that's compatible with UTF8, and apparently
your platform's version of "en_US" isn't.  Try specifying locale
en_US.utf8.  (There are various ways of spelling that --- "locale -a"
should give you a clue which one applies for you.)

            regards, tom lane