Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D61469FA1BB for ; Fri, 2 Feb 2007 15:51:57 -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 99122-05 for ; Fri, 2 Feb 2007 15:51:54 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s35.bay0.hotmail.com (bay0-omc3-s35.bay0.hotmail.com [65.54.246.235]) by postgresql.org (Postfix) with ESMTP id 9701F9FA08D for ; Fri, 2 Feb 2007 15:51:54 -0400 (AST) Received: from hotmail.com ([65.55.136.111]) by bay0-omc3-s35.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Fri, 2 Feb 2007 11:51:53 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 2 Feb 2007 11:51:52 -0800 Message-ID: Received: from 65.55.136.123 by by131fd.bay131.hotmail.msn.com with HTTP; Fri, 02 Feb 2007 19:51:50 GMT X-Originating-IP: [67.116.31.14] X-Originating-Email: [skarthi98@hotmail.com] X-Sender: skarthi98@hotmail.com From: "Karthikeyan Sundaram" To: pgsql-sql@postgresql.org Subject: Question regarding multibyte. Date: Fri, 02 Feb 2007 11:51:50 -0800 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 02 Feb 2007 19:51:52.0655 (UTC) FILETIME=[95C52DF0:01C74703] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.887 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/25 X-Sequence-Number: 27359 Hi, I am new to postgres. 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