X-Original-To: pgsql-jdbc-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AA143D1B1B9 for ; Sat, 17 Jul 2004 23:00:45 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51934-09 for ; Sun, 18 Jul 2004 02:00:46 +0000 (GMT) Received: from smtp812.mail.sc5.yahoo.com (smtp812.mail.sc5.yahoo.com [66.163.170.82]) by svr1.postgresql.org (Postfix) with SMTP id 3CEFBD1B19A for ; Sat, 17 Jul 2004 23:00:39 -0300 (ADT) Received: from unknown (HELO ANDYXP) (drlaz@sbcglobal.net@64.172.56.61 with login) by smtp812.mail.sc5.yahoo.com with SMTP; 18 Jul 2004 02:00:43 -0000 Message-ID: <075c01c46c6b$059ef320$847ba8c0@ANDYXP> From: "Andrew Lazarus" To: References: <40F98613.1060405@sistemat.com.ar> <16994.1090099096@sss.pgh.pa.us> <40F9B599.6080205@sistemat.com.ar> Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE Date: Sat, 17 Jul 2004 19:00:38 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/225 X-Sequence-Number: 10609 If you pg_dump in ASCII format, could you figure out what has happened to the 8-bit characters, if they are recognizable garbage (not truncated to some genuine character) you then write a sed script. It by hand, but it doesn't sound terrible.