Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id CF7FD9F9F08 for ; Fri, 17 Nov 2006 17:17:37 -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 96636-06 for ; Fri, 17 Nov 2006 17:17:31 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 3C51C9F9B3F for ; Fri, 17 Nov 2006 17:17:34 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from out1.smtp.messagingengine.com (out1.smtp.messagingengine.com [66.111.4.25]) by svr4.postgresql.org (Postfix) with ESMTP id 8C5235AF984 for ; Fri, 17 Nov 2006 21:17:33 +0000 (GMT) Received: from db2.internal (db2.internal [10.202.2.12]) by frontend1.messagingengine.com (Postfix) with ESMTP id 28E39DC8720; Fri, 17 Nov 2006 16:17:31 -0500 (EST) Received: from heartbeat2.messagingengine.com ([10.202.2.161]) by db2.internal (MEProxy); Fri, 17 Nov 2006 16:17:33 -0500 X-Sasl-enc: +OoDd38WfAg7pQUNi1q70MXaM2R7V6YWmHh/gdOuSPuw 1163798253 Received: from [17.214.82.236] (A17-214-82-236.apple.com [17.214.82.236]) by mail.messagingengine.com (Postfix) with ESMTP id 027FB124A4; Fri, 17 Nov 2006 16:17:17 -0500 (EST) In-Reply-To: <20061117165852.M2045@isb.com.pl> References: <20061117165852.M2045@isb.com.pl> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Drew Subject: Re: How convert UNICODE Date: Fri, 17 Nov 2006 13:17:05 -0800 To: lms X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/186 X-Sequence-Number: 26838 How about pg_dump the data from your old database, then load it into your new database which is using UTF8? Drew On Nov 17, 2006, at 9:09 AM, lms wrote: > 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. > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that > your > message can get through to the mailing list cleanly