Skip site navigation (1) Skip section navigation (2)

Re: 8.0.0beta4: "copy" and "client_encoding"

From: mbch67(at)yahoo(dot)com
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: 8.0.0beta4: "copy" and "client_encoding"
Date: 2004-11-04 07:08:43
Message-ID: fe065ce.0411032308.5b7a24b3@posting.google.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2004-11-04 10:17:22
Subject: Re: 8.0.0beta4: "copy" and "client_encoding"
Previous:From: Oliver JowettDate: 2004-11-03 21:23:38
Subject: Re: stable release

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group