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

From mbch67@yahoo.com
Subject Re: 8.0.0beta4: "copy" and "client_encoding"
Date
Msg-id fe065ce.0411032308.5b7a24b3@posting.google.com
Whole thread Raw
In response to 8.0.0beta4: "copy" and "client_encoding"  (mbch67@yahoo.com)
Responses Re: 8.0.0beta4: "copy" and "client_encoding"
Re: 8.0.0beta4: "copy" and "client_encoding"
List pgsql-jdbc
Thanks Kris and Oliver for your explanations.

Why I want to set the client_encoding to latin1? That's a fair
question. Unfortunately I removed the statement following the COPY
command to keep the posting short:

   SET CLIENT_ENCODING TO 'LATIN1';
   COPY temp_test FROM '/home/postgres/temp_test.dat';

I want to load a latin1-encoded file using the COPY command. Not
setting the encoding leads to the following error message:

   22021
   ERROR: Unicode characters greater than or equal to 0x10000 are
   not supported

Executing the same COPY statement with psql works fine.

Cheers,
Adrian

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: stable release
Next
From: Oliver Jowett
Date:
Subject: Re: 8.0.0beta4: "copy" and "client_encoding"