X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CF8C09DCA07 for ; Sun, 26 Mar 2006 05:38:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47402-01 for ; Sun, 26 Mar 2006 05:38:03 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from obelix.askesis.nl (laudanum.demon.nl [82.161.125.16]) by postgresql.org (Postfix) with ESMTP id 67D969DC876 for ; Sun, 26 Mar 2006 05:37:57 -0400 (AST) Received: obelix 172.31.0.1 from 172.31.1.1 172.31.1.1 via HTTP with MS-WebStorage 6.0.6249 Received: from panoramix by obelix; 26 Mar 2006 11:37:58 +0200 Subject: Re: Postgresql 8.1.3 Debian installation encoding question From: Joost Kraaijeveld To: Peter Eisentraut Cc: pgsql-admin@postgresql.org, Debian users In-Reply-To: <200603261020.55060.peter_e@gmx.net> References: <1143314597.7488.6.camel@localhost> <200603261020.55060.peter_e@gmx.net> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Sun, 26 Mar 2006 11:37:58 +0200 Message-Id: <1143365878.7278.6.camel@localhost> Mime-Version: 1.0 X-Mailer: Evolution 2.4.2.1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.123 required=5 tests=[AWL=0.122, UNPARSEABLE_RELAY=0.001, UPPERCASE_25_50=0] X-Spam-Score: 0.123 X-Spam-Level: X-Archive-Number: 200603/270 X-Sequence-Number: 21027 On Sun, 2006-03-26 at 10:20 +0200, Peter Eisentraut wrote: > It's derived from the locale, so make sure all your locales are set up > correctly. OK, but how is it derived? As far as I know, I did not change anything in the locales since the previous time I installed PostgreSQL. My locales are: jkr@panoramix:~$ locale LANG= LANGUAGE=en_US:en_GB LC_CTYPE="POSIX" LC_NUMERIC="POSIX" LC_TIME="POSIX" LC_COLLATE="POSIX" LC_MONETARY="POSIX" LC_MESSAGES="POSIX" LC_PAPER="POSIX" LC_NAME="POSIX" LC_ADDRESS="POSIX" LC_TELEPHONE="POSIX" LC_MEASUREMENT="POSIX" LC_IDENTIFICATION="POSIX" LC_ALL= I solved the immediate "problem" by doing an "initdb -E UTF8" but I am not quite satisfied by that sollution: it makes the installation of PostgreSQL more difficult for non-initiated users (including myself), who think that a simple "apt-get install' does the right thing. TIA Joost