Postgres Pro
Downloads
Home   >   mailing lists

Re: Invalid byte sequence when importing Oracle BLOB - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: Invalid byte sequence when importing Oracle BLOB
Date
Msg-id 20210426123259.GB26434@hjp.at
Whole thread Raw
In response to Invalid byte sequence when importing Oracle BLOB  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Invalid byte sequence when importing Oracle BLOB  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view 
On 2021-04-26 06:49:18 -0500, Ron wrote:
> The destination is an (RDS) Postgresql 12.5 with encoding UTF8, and is being
> loaded through COPY commands generated by ora2pg.
>
> The source table has a BLOB column (I think they are scanned images) which
> I'm loading into a Postgresql bytea column.
>
> Seven times out of about 60M rows, I get this error:
> Psql:909242: ERROR:  invalid byte sequence for encoding "UTF8": 0xed 0xaf 0xbf

Decoding UTF8 doesn't make sense for a bytea column. How does that data
look like in the file generated by ora2pg?

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"
Attachment

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: BRIN index on timestamptz
Next
From: Ron
Date:
Subject: Re: Invalid byte sequence when importing Oracle BLOB