X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8FE379FA5BA for ; Thu, 15 Jun 2006 08:10:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 84870-02 for ; Thu, 15 Jun 2006 08:10:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from fep07.ttnet.net.tr (mail.ttnet.net.tr [212.175.13.129]) by postgresql.org (Postfix) with ESMTP id ED6F89F9AD3 for ; Thu, 15 Jun 2006 08:10:35 -0300 (ADT) Received: from alamut ([212.174.26.173]) by fep07.ttnet.net.tr with ESMTP id <20060615111033.VSHG6194.fep07.ttnet.net.tr@alamut>; Thu, 15 Jun 2006 14:10:33 +0300 Date: Thu, 15 Jun 2006 14:08:15 +0300 From: Volkan YAZICI To: Milen Kulev Cc: pgsql-sql@postgresql.org Subject: Re: UTF-8 Problem ? Message-ID: <20060615110815.GB2469@alamut.tdm.local> References: <016d01c6906b$1e5c6570$0a00a8c0@trivadis.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <016d01c6906b$1e5c6570$0a00a8c0@trivadis.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/174 X-Sequence-Number: 25410 On Jun 15 01:01, Milen Kulev wrote: > I want to insert some german specific characters (umlaut characters) > into a table, but I am getting the following > Error message: > postgres=# EXECUTE stmt (1, 1 , 1 , 'Grün') ; > ERROR: invalid UTF-8 byte sequence detected near byte 0xfc > ... > postgres=# l\l > List of databases > Name | Owner | Encoding > ------------+-------+----------- > db1 | user1 | SQL_ASCII > postgres | pg | UTF8 > template0 | pg | UTF8 > template1 | pg | UTF8 Did you set your client_encoding properly too? (Also, assuming that your terminal supports the related client encoding.) Regards.