Re: [SQL] Question regarding multibyte.

From: "Karthikeyan Sundaram" <skarthi98(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Cc: pgsql-php(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: [SQL] Question regarding multibyte.
Date: 2007-02-04 21:34:41
Message-ID: BAY131-F8B75FE5FD2C5FD7127B30B0990@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. 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

_________________________________________________________________
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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Holdoway 2007-02-04 21:48:29 Re: blobs
Previous Message GABRIEL COLINA 2007-02-04 21:31:19 Gracias a todos por contestar sobre Consulta sobre Etica a la comunidad, recibo opiniones

Browse pgsql-php by date

  From Date Subject
Next Message Michael Fuhr 2007-02-04 22:30:32 Re: [PHP] [SQL] Question regarding multibyte.
Previous Message Gary Chambers 2007-02-03 04:09:08 Re: pg_[un]escape_bytea, pgsql 8.2.1, php 5.1.6, Linux

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2007-02-04 22:30:32 Re: [PHP] [SQL] Question regarding multibyte.
Previous Message Tom Lane 2007-02-02 20:28:33 Re: Nocount and scope_identity()