Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id EB12D9F9F08 for ; Fri, 17 Nov 2006 19:07:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.4]) (amavisd-new, port 10024) with ESMTP id 24555-08 for ; Fri, 17 Nov 2006 19:07:05 -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 B4ABC9F946B for ; Fri, 17 Nov 2006 19:07:08 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by isb.com.pl (Postfix) with ESMTP id CEE6EB13B6 for ; Sat, 18 Nov 2006 00:10:23 +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 04755-01 for ; Sat, 18 Nov 2006 00:10:19 +0100 (CET) Received: from mail.isb.com.pl (localhost.localdomain [127.0.0.1]) by isb.com.pl (Postfix) with ESMTP id 65019B13B4 for ; Sat, 18 Nov 2006 00:10:19 +0100 (CET) From: "lms" To: pgsql-sql@postgresql.org Subject: Re: How convert UNICODE Date: Sat, 18 Nov 2006 00:10:19 +0100 Message-Id: <20061117230302.M62231@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/189 X-Sequence-Number: 26841 Hi Yes, but I must convert diffrent columns to diffrent iso-codes. With pg_dump I can only dump all columns from database and these all columns convert only to one iso-code. On Fri, 17 Nov 2006 14:11:25 -0500, Travis Whitton wrote > There might be better ways, but you could dump the data and use the iconv utility. I frequently use it to convert to UTF-8 before loading data.