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

Поиск
Список
Период
Сортировка
От mbch67@yahoo.com
Тема Re: 8.0.0beta4: "copy" and "client_encoding"
Дата
Msg-id fe065ce.0411032308.5b7a24b3@posting.google.com
обсуждение исходный текст
Ответ на 8.0.0beta4: "copy" and "client_encoding"  (mbch67@yahoo.com)
Ответы Re: 8.0.0beta4: "copy" and "client_encoding"  (Oliver Jowett <oliver@opencloud.com>)
Re: 8.0.0beta4: "copy" and "client_encoding"  (Kris Jurka <books@ejurka.com>)
Список 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 по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: stable release
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: 8.0.0beta4: "copy" and "client_encoding"