Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id E2E9B1C3D21 for ; Tue, 20 Dec 2011 13:06:22 -0400 (AST) Received: from mail.affinitas.de ([91.102.12.84]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rd38u-0003Gq-5w for pgsql-admin@postgresql.org; Tue, 20 Dec 2011 17:06:21 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.affinitas.de (Postfix) with ESMTP id B515FA40BE for ; Tue, 20 Dec 2011 18:06:07 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at mail.affinitas.de Received: from mail.affinitas.de ([127.0.0.1]) by localhost (mail.affinitas.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id HoqZPdhlRszx for ; Tue, 20 Dec 2011 18:06:07 +0100 (CET) Received: from affinitas180.localnet (unknown [91.102.12.2]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.affinitas.de (Postfix) with ESMTPSA for ; Tue, 20 Dec 2011 18:06:07 +0100 (CET) From: Jens Wilke Organization: Affinitas GmbH To: pgsql-admin@postgresql.org Subject: Re: PG export/import encoding issue Date: Tue, 20 Dec 2011 18:06:06 +0100 User-Agent: KMail/1.13.5 (Linux/2.6.32-5-amd64; KDE/4.4.5; x86_64; ; ) References: <030501ccbe69$79cc56e0$6d6504a0$@thechillhacker.com> In-Reply-To: <030501ccbe69$79cc56e0$6d6504a0$@thechillhacker.com> MIME-Version: 1.0 Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <201112201806.06766.jens.wilke@affinitas.de> X-Pg-Spam-Score: -4.5 (----) X-Archive-Number: 201112/103 X-Sequence-Number: 38861 On Monday 19 December 2011 17:15:49 Scott Toland wrote: > the problem is the old schema was > an ASCII neutral zone, and the new server has the schema set for UTF-8 You have to convert the Dump: http://blog.endpoint.com/2011/12/sanitizing-supposed-utf-8-data.html HTH, Jens