UTF8 frustrations

From: jesse(dot)waters(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: UTF8 frustrations
Date: 2007-09-04 19:48:18
Message-ID: 8b3a63b10709041248u290606d9tf2018301ac4eda14@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Trying to do pg_restore from one UTF8 encoded db to another UTF8 encoded db
DB_source:
Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
psql 8.2.4

DB Destination:
Debian GNU/Linux 4.0
psql 8.1.9

I've tried:
pg_dump from the source box & from destination box

from destination server
pg_dump -i -h source_server db > db.8.1.9.sql

No matter which way I issue pg_dump command it always fails on the same record.

ERROR:
pg_restore: ERROR: invalid byte sequence for encoding "UTF8": 0xdf69
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 logs, line 69238382
pg_restore: [archiver (db)] error returned by PQendcopy: ERROR:
invalid byte sequence for encoding "UTF8": 0xdf69
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 logs, line 69238382

UTF8 to UTF8 and everything in between is UTF8, and it still fails,
I'm tempted to delete this record and keep going but I'm determined
to find a solution.

TIA for any help,

Jesse Waters

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-09-04 19:49:08 Re: SELECT question (splitting a field)
Previous Message Rodrigo De León 2007-09-04 19:23:10 Re: SELECT question (splitting a field)