Question regarding multibyte.

From: "Karthikeyan Sundaram" <skarthi98(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Question regarding multibyte.
Date: 2007-02-02 19:51:50
Message-ID: BAY131-F31397E07D032CF614B016FB09B0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-php pgsql-sql

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

_________________________________________________________________
Valentines 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shane Ambler 2007-02-02 20:33:25 Re: Postgres is not starting or stopping
Previous Message Jeff Frost 2007-02-02 17:22:14 Re: ADMIN Install Tsearch2 - new dic

Browse pgsql-php by date

  From Date Subject
Next Message ljb 2007-02-03 02:50:48 Re: pg_[un]escape_bytea, pgsql 8.2.1, php 5.1.6, Linux
Previous Message ellis 2007-02-02 05:32:59 Re: pg_[un]escape_bytea, pgsql 8.2.1, php 5.1.6, Linux

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2007-02-02 19:57:29 Re: Nocount and scope_identity()
Previous Message Demel, Jeff 2007-02-02 19:38:40 Re: Nocount and scope_identity()