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 990CF564A1 for ; Mon, 28 Feb 2005 20:51:27 +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 48979-08 for ; Mon, 28 Feb 2005 20:51:26 +0000 (GMT) Received: from web1-glo.biscit.net (web1-glo.biscit.net [82.195.96.53]) by svr1.postgresql.org (Postfix) with ESMTP id 45FC056498 for ; Mon, 28 Feb 2005 20:51:25 +0000 (GMT) Received: from bolek.coachhouse (host62-6-119-197.webport.bt.net [62.6.119.197]) by web1-glo.biscit.net (8.10.2/8.10.2) with ESMTP id j1SKpMB19060 for ; Mon, 28 Feb 2005 20:51:22 GMT Received: (Exim 3.36) #1 (Debian)) protocol: esmtp id 1D5roI-0000zP-00 ; Mon, 28 Feb 2005 20:48:10 +0000 Message-ID: <4223838A.7030904@numerixtechnology.de> Date: Mon, 28 Feb 2005 20:48:10 +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: psql encoding problem 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.102 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/8 X-Sequence-Number: 20488 Hello, I am trying to insert the following record: INSERT INTO item (name,retail_price) VALUES ('Cheese Soufflé',7.95,); (I presume you see the accented character in *Soufflé*) psql comes back with "invalid byte sequence for encoding "UNICODE": 0xe9" If I do this via DbVisualizer, the record is inserted fine. Is there any way around this problem? -- Regards/Gruß, Tarlika Elisabeth Schmitz