Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 57DA463359F for ; Fri, 12 Mar 2010 16:48:44 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 26390-06 for ; Fri, 12 Mar 2010 20:48:33 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id E3E9A633CBA for ; Fri, 12 Mar 2010 16:48:33 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 2C76B34C210; Fri, 12 Mar 2010 12:48:32 -0800 (PST) Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id yqjgEfL+vp5j; Fri, 12 Mar 2010 12:48:32 -0800 (PST) Received: from perhan.alvh.no-ip.org (unknown [190.95.5.4]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 3EC94348002; Fri, 12 Mar 2010 12:48:31 -0800 (PST) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id E3E846E82B; Fri, 12 Mar 2010 17:48:28 -0300 (CLST) Date: Fri, 12 Mar 2010 17:48:28 -0300 From: Alvaro Herrera To: "Wang, Mary Y" Cc: =?utf-8?Q?Micha=C5=82?= Pawlikowski , "pgsql-general@postgresql.org" Subject: Re: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error Message-ID: <20100312204828.GH3663@alvh.no-ip.org> References: <217ea9ed1003080438he2b4b47ke0fc078eaf70e346@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/515 X-Sequence-Number: 160508 Wang, Mary Y escribió: > Hi Michal, > > Thanks for the info. However, the text that the user entered is all in English letters. I saw this error, when I restored my database with the pg_dump --insert option. That row didn't get inserted to the table. What's interesting about this problem is that when I manually entered the data to the database via psql, this record made it without any problems. It's still a mystery to me ..... Well, 0x93 is certainly not an english letter; most likely it's a win1252-encoded curved single quote. That's not within the ASCII definition. You can probably insert the data by declaring SET client_encoding TO 'win1252' at the start of the file. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support