Re: error while trying to change the database encoding on a database

Adrian Klaver wrote:
> On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote:
>> 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
>                         ^^^^^^^ In the COPY command for that table.

I picked up ont that, but the dump is binary, thus I can not view the
actual code.

>
>> Is there any easy way to figure out which record caused this error?
>>
>> Thanks.
>>
>> --
>> Until later, Geoffrey
>
>
>
>


--
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