On Thu, Feb 01, 2007 at 07:01:31AM -0800, Karthikeyan Sundaram wrote:
> 1) How will I insert multibyte from insert statement? I figured out a way
> to insert multibyte, but want general opinion.
If you have UTF-8 data then treat it just like any other text string
and make sure client_encoding is set to 'UTF-8' or one of its aliases.
If the data is in some other encoding then set client_encoding
appropriately and the database will automatically convert the data
to the server's encoding.
> 2) I want the data to be transferred to warehouse.
Do you mean a data warehouse? What DBMS is the warehouse using?
What character encoding does it use? UTF-8 or something else?
> 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?
How did you "push to a flat file"? Did you use COPY or psql's
\copy? Does the data contain linefeeds and/or carriage returns?
Does the warehouse or your display understand UTF-8? If not then
you might need to use client_encoding or a program like iconv or
uconv to convert the data to another encoding.
--
Michael Fuhr