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 B9DFF9FA6A2 for ; Tue, 25 Jul 2006 16:29:42 -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-03 for ; Tue, 25 Jul 2006 16:29:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx2.surnet.cl (mx2.surnet.cl [216.155.73.181]) by postgresql.org (Postfix) with ESMTP id 78C0D9FA682 for ; Tue, 25 Jul 2006 16:29:38 -0300 (ADT) Received: from 200-126-100-4.bk7-dsl.surnet.cl (HELO alvh.no-ip.org) ([200.126.100.4]) by mx2.surnet.cl with ESMTP; 25 Jul 2006 15:29:37 -0400 X-IronPort-AV: i="4.07,180,1151899200"; d="scan'208"; a="66432307:sNHT19514020" Received: by alvh.no-ip.org (Postfix, from userid 1000) id 8539CC2F859; Tue, 25 Jul 2006 15:29:37 -0400 (CLT) Date: Tue, 25 Jul 2006 15:29:37 -0400 From: Alvaro Herrera To: Karen Springer Cc: pgsql-admin@postgresql.org Subject: Re: invalid UTF-8 byte sequences and iconv Message-ID: <20060725192937.GC21005@surnet.cl> Mail-Followup-To: Karen Springer , pgsql-admin@postgresql.org References: <44C66B33.3070504@wulfsberg.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <44C66B33.3070504@wulfsberg.com> User-Agent: Mutt/1.5.12-2006-07-14 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.029 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO X-Spam-Level: ** X-Archive-Number: 200607/212 X-Sequence-Number: 22458 Karen Springer wrote: > 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. Huh, maybe using the real source encoding instead? Try, for example, using Latin-1. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.