X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5212E5643F for ; Wed, 2 Mar 2005 16:43:00 +0000 (GMT) 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 19865-06 for ; Wed, 2 Mar 2005 16:42:55 +0000 (GMT) Received: from web1-glo.biscit.net (web1-glo.biscit.net [82.195.96.53]) by svr1.postgresql.org (Postfix) with ESMTP id 28A3B5643E for ; Wed, 2 Mar 2005 16:42:53 +0000 (GMT) Received: from bolek.coachhouse (host212-140-124-201.webport.bt.net [212.140.124.201]) by web1-glo.biscit.net (8.10.2/8.10.2) with ESMTP id j22GgmB21878 for ; Wed, 2 Mar 2005 16:42:48 GMT Received: (Exim 3.36) #1 (Debian)) protocol: esmtp id 1D6Wvr-000278-00 ; Wed, 02 Mar 2005 16:42:43 +0000 Message-ID: <4225ED03.7010405@numerixtechnology.de> Date: Wed, 02 Mar 2005 16:42:43 +0000 From: T E Schmitz Reply-To: mailreg@numerixtechnology.de User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: psql encoding problem References: <4223838A.7030904@numerixtechnology.de> <1109750238.16690.101.camel@localhost.localdomain> In-Reply-To: <1109750238.16690.101.camel@localhost.localdomain> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/24 X-Sequence-Number: 20503 Hello Ragnar, Ragnar Hafstað wrote: > On Mon, 2005-02-28 at 20:48 +0000, T E Schmitz wrote: > > >>INSERT INTO item (name,retail_price) VALUES ('Cheese Soufflé',7.95,); >> >>psql comes back with "invalid byte sequence for encoding "UNICODE": 0xe9" > > might be the client encoding. > set client_encoding='LATIN1'; sorted my problem - many thanks! > gnari -- Regards/Gruß, Tarlika