Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E71E09FB1CD for ; Tue, 28 Nov 2006 07:55:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 97526-04 for ; Tue, 28 Nov 2006 07:55:31 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web58315.mail.re3.yahoo.com (web58315.mail.re3.yahoo.com [68.142.236.168]) by postgresql.org (Postfix) with SMTP id 325149FA8EF for ; Tue, 28 Nov 2006 07:55:36 -0400 (AST) Received: (qmail 3296 invoked by uid 60001); 28 Nov 2006 11:48:54 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=ttxX2XtD0E3j+KQWEeH7Pgzw1nSuOSQkYMDmCpKKg1ZW7+dsI/ZdebkV3sSUWSuKdlgT9j08CyyCeofJyu64gEkTXgC/fER+svQ0psxsLs7Pw15cH8NIZqokI5rIgE2SjkuerB8+C4UQ9R1juVPBMOEf1uD1/LFtpPdbO4YNprE= ; Message-ID: <20061128114854.3294.qmail@web58315.mail.re3.yahoo.com> Received: from [129.165.226.2] by web58315.mail.re3.yahoo.com via HTTP; Tue, 28 Nov 2006 03:48:54 PST Date: Tue, 28 Nov 2006 03:48:54 -0800 (PST) From: Jessica Richard Subject: how do I load a 8.0.8 database with unicode encoding into 8.1.4/utf8? To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1766171548-1164714534=:2680" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.944 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200611/225 X-Sequence-Number: 23752 --0-1766171548-1164714534=:2680 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit got an errro when loading a db from 8.0.8 with unicode to 8.1.4 server with UTF8 server: ERROR: invalid byte sequence for encoding "UTF8": 0x92 thanks, Jessica --------------------------------- Everyone is raving about the all-new Yahoo! Mail beta. --0-1766171548-1164714534=:2680 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit got an errro when loading a db from 8.0.8 with unicode to 8.1.4 server with UTF8 server:
ERROR:  invalid byte sequence for encoding "UTF8": 0x92

thanks,
Jessica


Everyone is raving about the all-new Yahoo! Mail beta. --0-1766171548-1164714534=:2680--