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

Bogdan Mihaila wrote:
> 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

There is a byte sequence that's invalid for UTF-8 on line 51 in the dump
file. I believe 8.3 is stricter about rejecting invalid UTF-8 strings
than previous versions, so it's possible that you had a garbled
character in the 8.1 database, which throws an error when copied into a
8.3 server. You need to fix the invalid character either in the dump
file or in the 8.1 database.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com