Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A50F79FB28A; Sun, 4 Feb 2007 17:34:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 71688-04; Sun, 4 Feb 2007 17:34:48 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc1-s15.bay0.hotmail.com (bay0-omc1-s15.bay0.hotmail.com [65.54.246.87]) by postgresql.org (Postfix) with ESMTP id E91C49FA4DF; Sun, 4 Feb 2007 17:34:47 -0400 (AST) Received: from hotmail.com ([65.55.136.88]) by bay0-omc1-s15.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Sun, 4 Feb 2007 13:34:46 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sun, 4 Feb 2007 13:34:46 -0800 Message-ID: Received: from 65.55.136.123 by by131fd.bay131.hotmail.msn.com with HTTP; Sun, 04 Feb 2007 21:34:41 GMT X-Originating-IP: [67.169.184.232] X-Originating-Email: [skarthi98@hotmail.com] X-Sender: skarthi98@hotmail.com In-Reply-To: From: "Karthikeyan Sundaram" To: pgsql-sql@postgresql.org Cc: pgsql-php@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [SQL] Question regarding multibyte. Date: Sun, 04 Feb 2007 13:34:41 -0800 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 04 Feb 2007 21:34:46.0179 (UTC) FILETIME=[4A4DAF30:01C748A4] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.976 tagged_above=0 required=5 tests=AWL, BAYES_40, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/49 X-Sequence-Number: 24514 Hi, I am new to postgres. I asked a question regarding multibyte display. I got only one response. Hence, I am re-iterating the question again to a larger audience. We are using 8.2 release of postgres. Recently we converted our database to multibyte on our dev machine. we want to test the following. 1) How will I insert multibyte from our php? Do we need to use any special encoding? 2) I am using psql command line to get the data into a flat file and push to our data warehouse We use IBM redbrick warehouse. 3) If I have multibyte, I know the output from the psql will scatter to many lines. How can we avoid that. What is the sql command ? I need 1 record per row to supply to our warehouse. Can somebody help me? Regards skarthi _________________________________________________________________ Valentine’s Day -- Shop for gifts that spell L-O-V-E at MSN Shopping http://shopping.msn.com/content/shp/?ctId=8323,ptnrid=37,ptnrdata=24095&tcode=wlmtagline