Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id E369D9F931E for ; Fri, 24 Nov 2006 03:08:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 64889-04-3 for ; Fri, 24 Nov 2006 07:08:22 +0000 (UTC) X-Greylist: delayed 00:11:36.838439 by SQLgrey-1.7.4 Received: from mail.dbasetek.com (h-66-134-184-74.chcgilgm.covad.net [66.134.184.74]) by postgresql.org (Postfix) with ESMTP id DC3109FB2D3 for ; Fri, 24 Nov 2006 01:51:04 -0400 (AST) Received: from [192.168.1.51] ([192.168.1.51]) by mail.dbasetek.com (8.12.11/8.12.11) with ESMTP id kAO5dKVc015675 for ; Thu, 23 Nov 2006 23:39:20 -0600 Message-ID: <4566858C.6010406@dbasetek.com> Date: Thu, 23 Nov 2006 23:39:24 -0600 From: Robert D Oden Organization: Database Marketing Technologies Inc User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: PgSQL ADMIN Subject: Converting CP1252 to UTF-8 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-DMT-MailScanner-Information: Please contact the ISP for more information X-DMT-MailScanner: Found to be clean X-DMT-MailScanner-From: roden@dbasetek.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/207 X-Sequence-Number: 23734 I have a total of 60GB's in several database with encoding set to SQL_ASCII. I am using version 8.0. The data has always been encoded in CP1252 prior to inserting into the database. I have characters between 0x80 and 0x9F scattered throughout the databases which I cannot loose. I noticed in version 8.1 I can set the database encoding to WIN1252. Will the following work to keep from loosing the above characters: Upgrade to 8.1 Create the databases in CP1252 Restore the data Dump the databases again to set the appropriate encoding in the dump file Create the databases with UTF-8 encoding Restore the data Thanks in advance, Doug -- Robert D Oden Database Marketing Technologies, Inc 951 Locust Hill Circle Belton MO 64012-1786 Ph: 816-318-8840 Fax: 816-318-8841 roden@dbasetek.com