Re: 8.0.0beta4: "copy" and "client_encoding" - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: 8.0.0beta4: "copy" and "client_encoding"
Date
Msg-id Pine.BSO.4.56.0411081919080.16232@leary.csoft.net
Whole thread Raw
In response to Re: 8.0.0beta4: "copy" and "client_encoding"  ("Barry Lind" <blind@xythos.com>)
List pgsql-jdbc
Well, lets ask -hackers...

When COPYing data from a file, the file encoding is taken from the
client_encoding parameter.  The JDBC driver always uses UNICODE as the
client_encoding and wants to prevent people from changing it by
monitoring ParameterStatus messages and erroring out if it's changed.
This presents a problem when you want to COPY to or from a file with a
different encoding.  It seems reasonable to add an ENCODING specification
to the COPY command instead of relying on the somewhat unrelated
client_encoding setting.  Oliver Jowett also noted that copying from a
file with LATIN1 data into a table whose name contained UNICODE characters
could not be done.  Does this seem like a reasonable thing to do?

Kris Jurka

On Mon, 8 Nov 2004, Barry Lind wrote:

> I am assuming this will get addressed in the backend in 8.1 and that
> would be the upgrade path.  (I agree if there isn't agreement on the
> server side that this is appropriate for the server, then this wouldn't
> be the correct parameter).
>
> --Barry
>

pgsql-jdbc by date:

Previous
From: "J. Michael Crawford"
Date:
Subject: Re: [GENERAL] Using Postgres with Latin1 (ISO8859-1)
Next
From: Kris Jurka
Date:
Subject: driver beta release