Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 8E8852E0054 for ; Wed, 2 Apr 2008 06:05:11 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 14692-10 for ; Wed, 2 Apr 2008 06:05:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by developer.postgresql.org (Postfix) with ESMTP id 460C52E0039 for ; Wed, 2 Apr 2008 06:05:06 -0300 (ADT) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1Jgyty-0007LM-Fl for pgsql-admin@postgresql.org; Wed, 02 Apr 2008 09:05:02 +0000 Received: from srv.protecting.net ([212.126.218.242]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 02 Apr 2008 09:05:02 +0000 Received: from hari.fuchs by srv.protecting.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 02 Apr 2008 09:05:02 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Harald Fuchs Subject: Re: ERROR: encoding LATIN9 does not match server's locale en_US Date: Wed, 02 Apr 2008 11:02:21 +0200 Lines: 18 Message-ID: References: <47F270CA.8040407@andromeiberica.com> <11865.1207073502@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: srv.protecting.net X-Archive: encrypt User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.2 (gnu/linux) Cancel-Lock: sha1:ADNeLjcm0kB+2RioCdOZnjfMMY0= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/18 X-Sequence-Number: 28782 In article <11865.1207073502@sss.pgh.pa.us>, Tom Lane writes: > Arnau 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...).