Re: ERROR: encoding LATIN9 does not match server's locale en_US

From: Harald Fuchs <hari(dot)fuchs(at)googlemail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: ERROR: encoding LATIN9 does not match server's locale en_US
Date: 2008-04-02 09:02:21
Message-ID: puej9oy6hu.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

In article <11865(dot)1207073502(at)sss(dot)pgh(dot)pa(dot)us>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Arnau <arnaulist(at)andromeiberica(dot)com> writes:
>> template1=# create database test with encoding='LATIN9';
>> ERROR: encoding LATIN9 does not match server's locale en_US
>> DETAIL: The server's LC_CTYPE setting requires encoding LATIN1.

>> I've been looking into the documentation to fix this and the only way
>> I have found is to use initdb to recreate the cluster, Is there any
>> other option?

> Nope, sorry. If you need to change the database locale, you have to
> re-initdb.

Are there any characters in American English which are covered by
Latin-1, but not by Latin-9? I consider Latin-1 mostly obsolete (no
French OE ligature, no Euro sign...).

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message yogesh 2008-04-02 11:23:41 POSTGRESQL LOG
Previous Message Joe Blackham 2008-04-01 22:46:34 New code added to odbc driver