| From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
|---|---|
| To: | Bogdan Mihaila <bm2004mvc(at)yahoo(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #5164: COPY command: invalid byte sequence 0x80 |
| Date: | 2009-11-04 12:36:15 |
| Message-ID: | 4AF1753F.3040303@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2009-11-04 12:53:34 | Re: BUG #4961: pg_standby.exe crashes with no args |
| Previous Message | Craig Ringer | 2009-11-04 12:30:35 | Re: BUG #5163: Admin can't connect and won't use port 5432 |