Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 801C89F9B3F for ; Fri, 17 Nov 2006 18:57:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 03486-10 for ; Fri, 17 Nov 2006 18:57:32 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from isb.com.pl (poczta.isb.com.pl [80.48.198.2]) by postgresql.org (Postfix) with ESMTP id 44DB79FA0C4 for ; Fri, 17 Nov 2006 18:57:31 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by isb.com.pl (Postfix) with ESMTP id 88E6FB13B6 for ; Sat, 18 Nov 2006 00:00:45 +0100 (CET) Received: from isb.com.pl ([127.0.0.1]) by localhost (isb.com.pl [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04466-07 for ; Sat, 18 Nov 2006 00:00:44 +0100 (CET) Received: from mail.isb.com.pl (localhost.localdomain [127.0.0.1]) by isb.com.pl (Postfix) with ESMTP id 28335B13B4 for ; Sat, 18 Nov 2006 00:00:44 +0100 (CET) From: "lms" To: pgsql-sql@postgresql.org Subject: Re: How convert UNICODE Date: Sat, 18 Nov 2006 00:00:44 +0100 Message-Id: <20061117225420.M66174@inetcafe.eu.org> In-Reply-To: References: <20061117165852.M2045@isb.com.pl> X-Mailer: Open WebMail 2.50 20050106 X-OriginatingIP: 80.48.198.7 (piechcio) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at isb.com.pl X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/187 X-Sequence-Number: 26839 Hi New database must be in SQL_ASCII. In old database (UNICODE) are for example 2 columns. Rows from first column I must convert to ISO_8859_2 and insert it to first column in SQL_ASCII database, and rows from second column I must convert to IS0_8859_5 and insert to second column in SQL_ASCII database. On Fri, 17 Nov 2006 13:17:05 -0800, Drew wrote > How about pg_dump the data from your old database, then load it into > your new database which is using UTF8? > > Drew