X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 36B7132A60E for ; Thu, 14 Oct 2004 05:21:47 +0100 (BST) 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 42297-06 for ; Thu, 14 Oct 2004 04:21:33 +0000 (GMT) Received: from www.mischko.com (unknown [69.93.197.224]) by svr1.postgresql.org (Postfix) with ESMTP id 7B9A132C711 for ; Thu, 14 Oct 2004 05:21:32 +0100 (BST) Received: from willy.mischko.com (d15-159.rb.vcr.centurytel.net [69.29.250.159]) by www.mischko.com (Postfix) with ESMTP id AE7D555F2A for ; Thu, 14 Oct 2004 00:21:31 -0400 (EDT) From: Scott Chapman To: pgsql-admin@postgresql.org Subject: Export from 7.4 and import to 8.0 - unicode errors Date: Wed, 13 Oct 2004 21:28:20 -0700 User-Agent: KMail/1.7 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200410132128.20685.scott_list@mischko.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/175 X-Sequence-Number: 15168 I'm getting Unicode errors when I export (with pg_dump) my database from version 7.4 and then import it into a new 8.0 database (with psql). The situation is that this data has fields with ascii characters in them and utf-8 characters also. Both types of characters are in a given field. The entire dump is NOT utf-8 encoded. I can't figure out how to get this to be imported into the new database without errors unless I turn the entire thing into utf-8 using recode. That does not work well because the fields in question have to be utf8_decoded (in php) TWICE before they display correctly. How do I deal with this? It's got me very puzzled! Thanks! Scott