BUG #5164: COPY command: invalid byte sequence 0x80

From: "Bogdan Mihaila" <bm2004mvc(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5164: COPY command: invalid byte sequence 0x80
Date: 2009-11-04 09:05:55
Message-ID: 200911040905.nA495tej084019@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5164
Logged by: Bogdan Mihaila
Email address: bm2004mvc(at)yahoo(dot)com
PostgreSQL version: 8.1 and 8.3
Operating system: Linux
Description: COPY command: invalid byte sequence 0x80
Details:

Hello!

I searched the internet for this problem, but I didn't find an answer.
Please help me.

I make a COPY TO command (in a 8.1 version, under Linux) for a table that
contains text in the UTF-8 encoding. The command is:

set client_encoding = 'utf8';
DROP TABLE "acte1";
CREATE TEMP TABLE "acte1" AS
SELECT * FROM "Oficiale"."acte" WHERE id = 57502;
COPY "acte1" TO '/home/bogdanm/eugen.copy';

Then I make a COPY FROM (in a 8.3 version,under the same Linux machine as
above) like this:

set client_encoding = 'utf8';
copy "Oficiale"."acte" from '/home/bogdanm/eugen.copy'

It works!

But, where I specify the interval like this:

WHERE id > 57500 and id < 57600;

it doesn't work, saying:

ERROR: invalid byte sequence for encoding "UTF8": 0x80
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
CONTEXT: COPY acte, line 51

Why is that? The second range obviously contains the first...

Thanks very much in advance,
Bogdan

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Fujii Masao 2009-11-04 10:40:19 Re: BUG #4961: pg_standby.exe crashes with no args
Previous Message Craig Ringer 2009-11-04 04:44:39 Re: BUG #5163: Admin can't connect and won't use port 5432