From: | Adrian Klaver <aklaver(at)comcast(dot)net> |
---|---|
To: | Peter Headland <pheadland(at)actuate(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: COPY command character set |
Date: | 2009-09-10 18:06:08 |
Message-ID: | 352574087.4306311252605968533.JavaMail.root@sz0030a.emeryville.ca.mail.comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
----- "Peter Headland" <pheadland(at)actuate(dot)com> wrote:
> > The COPY command reference page saith
> >
> > Input data is interpreted according to the current client
> encoding,
> > and output data is encoded in the the current client encoding,
> even
> > if the data does not pass through the client but is read from or
> > written to a file.
>
> Rats - I read the manual page twice and that didn't register on my
> feeble consciousness. I suspect that I didn't look beyond the word
> "client", since I knew I wasn't interested in client behavior and I
> was
> speed-reading. On the assumption that I am not uniquely stupid, maybe
> we
> could re-phrase this slightly, with a "for example", and add a
> heading
> "Localization"?
>
> As a general comment, I18N/L10N is a hairy enough topic that it
> merits
> its own heading in any commands where it is an issue.
>
> How about my suggestion to add a means (extend COPY syntax) to
> specify
> encoding explicitly and handle UTF lead bytes - would that be of
> interest?
>
> --
> Peter Headland
> Architect
> Actuate Corporation
>
>
> The COPY command reference page saith
>
> Input data is interpreted according to the current client
> encoding,
> and output data is encoded in the the current client encoding,
> even
> if the data does not pass through the client but is read from or
> written to a file.
>
> Seems clear enough to me.
>
> regards, tom lane
Maybe the link might help?
http://www.postgresql.org/docs/8.4/interactive/multibyte.html
Adrian Klaver
aklaver(at)comcast(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-09-10 18:12:55 | Re: COPY command character set |
Previous Message | David Brain | 2009-09-10 18:03:13 | Unable to drop a table due to seemingly non-existent dependencies |