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 C2F0AD9B4E for ; Mon, 10 Oct 2005 07:35:51 -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 09210-02 for ; Mon, 10 Oct 2005 10:35:47 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id CEB8AD9B00 for ; Mon, 10 Oct 2005 07:35:48 -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 j9AAZk3t015713 for ; Mon, 10 Oct 2005 10:35:46 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j9AA8CKe059604 for pgsql-admin@postgresql.org; Mon, 10 Oct 2005 10:08:12 GMT (envelope-from news) From: Hannes Dorbath X-Newsgroups: pgsql.admin Subject: Re: character problem Date: Mon, 10 Oct 2005 12:08:29 +0200 Organization: Hub.Org Networking Services Lines: 32 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: To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.448 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.372] X-Spam-Level: X-Archive-Number: 200510/105 X-Sequence-Number: 19177 On 10.10.2005 11:56, Luca Ferrari wrote: > gestione_personale=# \l > List of databases > Name | Owner | Encoding > --------------------+-----------+----------- > gestione_database | dbmanager | SQL_ASCII > gestione_personale | wwwrun | SQL_ASCII > template0 | dbmanager | SQL_ASCII > template1 | dbmanager | SQL_ASCII > (4 rows) > > gestione_personale=# show client_encoding; > client_encoding > ----------------- > SQL_ASCII > (1 row) OK, so you are not using Unicode. I don't know much about the SQL_ASCII charset, but I expect it to slightly differ from LATIN1. Type SET client_encoding = LATIN1; in psql, then SELECT some data containing the chars you have problems with and see if it is fixed. If not, INSERT a new row with such chars from psql, SELECT that row again and if the chars look right now, your other rows are stored invalid in the datebase and you need to convert them somehow. -- Regards, Hannes Dorbath