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 13F6A32BB15 for ; Thu, 14 Oct 2004 07:14:43 +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 66518-05 for ; Thu, 14 Oct 2004 06:14:39 +0000 (GMT) Received: from web11.manitu.net (web11.manitu.net [217.11.48.111]) by svr1.postgresql.org (Postfix) with ESMTP id 1AB9732BB0C for ; Thu, 14 Oct 2004 07:14:36 +0100 (BST) Received: from [192.168.0.1] (dsl-082-082-191-162.arcor-ip.net [82.82.191.162]) (authenticated) by web11.manitu.net (8.10.2-SOL3/8.10.2) with ESMTP id i9E6ETw18347; Thu, 14 Oct 2004 08:14:29 +0200 Subject: Re: Export from 7.4 and import to 8.0 - unicode errors From: Markus Bertheau To: Scott Chapman Cc: pgsql-admin@postgresql.org In-Reply-To: <200410132128.20685.scott_list@mischko.com> References: <200410132128.20685.scott_list@mischko.com> Content-Type: text/plain; charset=UTF-8 Message-Id: <1097734472.2880.8.camel@teetnang> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 14 Oct 2004 08:14:32 +0200 Content-Transfer-Encoding: quoted-printable 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/176 X-Sequence-Number: 15169 =D0=92 =D0=A7=D1=82=D0=B2, 14.10.2004, =D0=B2 06:28, Scott Chapman =D0=BF= =D0=B8=D1=88=D0=B5=D1=82: > I'm getting Unicode errors when I export (with pg_dump) my database from= =20 > version 7.4 and then import it into a new 8.0 database (with psql).=20 >=20 > The situation is that this data has fields with ascii characters in them = and=20 > utf-8 characters also. Both types of characters are in a given field. T= he=20 > entire dump is NOT utf-8 encoded. ASCII is a subset of UTF-8, so every ASCII character is a UTF-8 character, too. > I can't figure out how to get this to be imported into the new database= =20 > without errors unless I turn the entire thing into utf-8 using recode. Th= at=20 > does not work well because the fields in question have to be utf8_decoded= (in=20 > php) TWICE before they display correctly. >=20 > How do I deal with this? It's got me very puzzled! What encoding is the 7.4 database in? What encoding is the 8.0 database in? Did you set client_encoding? What's the error message? --=20 Markus Bertheau