Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id E5C549F9F7F for ; Fri, 17 Nov 2006 13:06:29 -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 67945-07 for ; Fri, 17 Nov 2006 13:06:28 -0400 (AST) X-Greylist: delayed 21:16:10.883414 by SQLgrey- Received: from isb.com.pl (poczta.isb.com.pl [80.48.198.2]) by postgresql.org (Postfix) with ESMTP id 9C6C29F9EED for ; Fri, 17 Nov 2006 13:06:28 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by isb.com.pl (Postfix) with ESMTP id 694C4B13B6 for ; Fri, 17 Nov 2006 18:09:39 +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 03561-06 for ; Fri, 17 Nov 2006 18:09:38 +0100 (CET) Received: from mail.isb.com.pl (localhost.localdomain [127.0.0.1]) by isb.com.pl (Postfix) with ESMTP id 0B1C5B13B4 for ; Fri, 17 Nov 2006 18:09:38 +0100 (CET) From: "lms" To: pgsql-sql@postgresql.org Subject: How convert UNICODE Date: Fri, 17 Nov 2006 18:09:37 +0100 Message-Id: <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/184 X-Sequence-Number: 26836 Hello I have 2 databases with same table. First database is in UNICODE, second in SQL_ASCII. 4 columns from first database I must convert to: (first column)iso8859-1, (second column)iso8859-2, (3-th column)iso8859-1, (4 column)iso8859-5. After it I must save these 4 rows in database in SQL_ASCII. How can I do it? It can be using libpq,libpgeasy,.... Thx.