X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 379FCD9B17 for ; Mon, 10 Oct 2005 06:05:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75818-05 for ; Mon, 10 Oct 2005 09:05:46 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id C22ECD9B4E for ; Mon, 10 Oct 2005 06:05:47 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j9A95k8V095937 for ; Mon, 10 Oct 2005 09:05:46 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j9A90AF3088529 for pgsql-admin@postgresql.org; Mon, 10 Oct 2005 09:00:10 GMT (envelope-from news) From: Hannes Dorbath X-Newsgroups: pgsql.admin Subject: Re: character problem Date: Mon, 10 Oct 2005 11:00:27 +0200 Organization: Hub.Org Networking Services Lines: 13 Message-ID: References: <4349106C.6080206@infinito.it> <434A2792.1070106@infinito.it> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.4 (Windows/20050908) In-Reply-To: <434A2792.1070106@infinito.it> To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.451 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.369] X-Spam-Level: X-Archive-Number: 200510/103 X-Sequence-Number: 19175 On 10.10.2005 10:34, Luca Ferrari wrote: > Do you mean dumping the database, destroying it and then recreating it? > I'm sorry, but I'm still new in postgresql, thus it is not clear if > meant that or another trick I don't know. Let us find the problem before jumping to solutions. Start psql , type \l inside it and paste the output for the database in question. Then type "show client_encoding;" and paste the output as well, please. -- Regards, Hannes Dorbath