X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C13E89FA682 for ; Tue, 25 Jul 2006 16:27:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 85733-01 for ; Tue, 25 Jul 2006 16:26:52 -0300 (ADT) X-Greylist: delayed 00:21:50.511689 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id C7B859FAE4E for ; Tue, 25 Jul 2006 16:26:19 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mead.wulfsberg.com (unknown [216.185.173.34]) by svr4.postgresql.org (Postfix) with ESMTP id 361AC5AFB26 for ; Tue, 25 Jul 2006 19:04:26 +0000 (GMT) Received: from [10.0.3.243] (esperante.wulfsberg.com [10.0.3.243]) (authenticated bits=0) by mead.wulfsberg.com (8.12.8/8.12.8) with ESMTP id k6PJ4IR5010807 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 25 Jul 2006 12:04:20 -0700 Message-ID: <44C66B33.3070504@wulfsberg.com> Date: Tue, 25 Jul 2006 12:04:19 -0700 From: Karen Springer Organization: Wulfsberg Electronics User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: invalid UTF-8 byte sequences and iconv Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200607/211 X-Sequence-Number: 22457 Hi, We have set up a new server and are needing to move our database from 7.3 to 8.1.4. On restore I'm getting the 'invalid UTF-8 byte sequence' error message. If I use the command iconv -c -f UTF-8 -t UTF-8 -o cleanfile.sql dumpfile.sql, then the characters are deleted and the restore goes smoothly. The problem is that we want those characters. They are for example the degree symbol and the micro symbol. Is there anyway to bring these characters over? Thanks in advance. Karen