Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 912CA9FA2BB for ; Thu, 1 Feb 2007 11:01:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 71702-02 for ; Thu, 1 Feb 2007 11:01:28 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc2-s5.bay0.hotmail.com (bay0-omc2-s5.bay0.hotmail.com [65.54.246.141]) by postgresql.org (Postfix) with ESMTP id BE4A49F9AFC for ; Thu, 1 Feb 2007 11:01:34 -0400 (AST) Received: from hotmail.com ([65.55.136.98]) by bay0-omc2-s5.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Thu, 1 Feb 2007 07:01:32 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 1 Feb 2007 07:01:32 -0800 Message-ID: Received: from 65.55.136.123 by by131fd.bay131.hotmail.msn.com with HTTP; Thu, 01 Feb 2007 15:01:31 GMT X-Originating-IP: [67.169.184.232] X-Originating-Email: [skarthi98@hotmail.com] X-Sender: skarthi98@hotmail.com From: "Karthikeyan Sundaram" To: pgsql-admin@postgresql.org Subject: questions on multibyte Date: Thu, 01 Feb 2007 07:01:31 -0800 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 01 Feb 2007 15:01:32.0426 (UTC) FILETIME=[DC176EA0:01C74611] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.797 tagged_above=0 required=5 tests=BAYES_05, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/5 X-Sequence-Number: 24470 Hi all, I am new to postgres. I have converted my current db from sql_ascii to unicode. I followed the instructions give by some site called moodle and it worked. I have some basic questions. 1) How will I insert multibyte from insert statement? I figured out a way to insert multibyte, but want general opinion. 2) I want the data to be transferred to warehouse. 3) I login to psql and do a select the multibyte. (I did a plain select). and push to a flat file so that the warehouse will upload. The data appread to be scatterd to multiple lines which I am not able to insert into my warehouse. How will display the multibyte chars from psql command line? 4) Do I need to install some modules or functions or any methods? Please advise. Regards skarthi Podbridge Inc _________________________________________________________________ Turn searches into helpful donations. Make your search count. http://click4thecause.live.com/search/charity/default.aspx?source=hmemtagline_donation&FORM=WLMTAG