error while trying to change the database encoding on a database

From: Geoffrey Myers <lists(at)serioustechnology(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: error while trying to change the database encoding on a database
Date: 2011-01-24 14:38:55
Message-ID: 4D3D8EFF.3050405@serioustechnology.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We need to change the database encoding on our databases as they were
created with the wrong encoding. They were created as SQL_ASCII and we
are changing them to UTF8.

When testing this Friday, I received the following error:

pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 5225; 0 16990 TABLE
DATA cust postgres
pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence
for encoding "UTF8": 0xb0
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 cust, line 778

Is there any easy way to figure out which record caused this error?

Thanks.

--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey Myers 2011-01-24 15:00:24 searching for characters via the hexidecimal value
Previous Message orgilhp 2011-01-24 06:13:54 Re: Read problem from Bytea column