Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7280A2E31BF for ; Sat, 9 Feb 2008 10:29:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 08465-05 for ; Sat, 9 Feb 2008 10:28:58 -0400 (AST) Received: from smtp123.sbc.mail.re3.yahoo.com (smtp123.sbc.mail.re3.yahoo.com [66.196.96.96]) by postgresql.org (Postfix) with SMTP id 145B62E3225 for ; Sat, 9 Feb 2008 10:29:06 -0400 (AST) Received: (qmail 89485 invoked from network); 9 Feb 2008 14:29:04 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=sbcglobal.net; h=Received:X-YMail-OSG:X-Yahoo-Newman-Property:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:X-Enigmail-Version:Content-Type:Content-Transfer-Encoding; b=0T7lUSL56/fEPi0XCMgvchTJhSLrDWW+tXu4dVrkSJL3MztGZSM0E8RXCsT1M1NI/dRJRefCoGYsVpvSzSP4DRe5zm2L7JvsJQalVAyKFSgt74aQapQezxrbglZIFHICZMvIgBnZwD7mi3x3AIxF+IQR/3GQCsk519ACJhlZwSA= ; Received: from unknown (HELO ?192.168.1.100?) (maiku41@sbcglobal.net@68.74.115.232 with plain) by smtp123.sbc.mail.re3.yahoo.com with SMTP; 9 Feb 2008 14:29:04 -0000 X-YMail-OSG: lBnubdkVM1lJgXgMAHIKWM0798V48C.WvGymHRycjULhRzLgSi6NKQLbpCDiISXs.PPn31d8.T8zWZKrrbr8BvKJ0viNEc2pHnXOI2L.c2V8Ak7dqhecrgNDd6cFxZf2pUrCUZT0SGcguw-- X-Yahoo-Newman-Property: ymail-3 Message-ID: <47ADB8AA.6070305@sbcglobal.net> Date: Sat, 09 Feb 2008 08:28:58 -0600 From: Mike Blackwell User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Character encoding conversion X-Enigmail-Version: 0.95.6 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.16 tagged_above=0 required=5 tests=AWL=0.159, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200802/115 X-Sequence-Number: 28189 I have a database which was originally created with LATIN1 encoding. I'd like to move it to UTF8. The data will load ok (COPY) but I am getting 'invalid byte sequence for encoding..." messages when accessing the data. Is there a way to automatically convert the offending characters, or to easily locate them in a pg_dump file so they can be converted by hand? Mike