From: Harald Fuchs <hari.fuchs@googlemail.com>
To: pgsql-admin@postgresql.org
Subject: Re: ERROR: encoding LATIN9 does not match server's locale en_US
Date: Wed, 02 Apr 2008 11:02:21 +0200
Message-ID: <puej9oy6hu.fsf@srv.protecting.net> (raw)
References: <47F270CA.8040407@andromeiberica.com>
<11865.1207073502@sss.pgh.pa.us>
In article <11865.1207073502@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> writes:
> Arnau <arnaulist@andromeiberica.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...).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: hari.fuchs@googlemail.com
Subject: Re: ERROR: encoding LATIN9 does not match server's locale en_US
In-Reply-To: <puej9oy6hu.fsf@srv.protecting.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox