Answer the question
In order to leave comments, you need to log in
Replication from Oracle to PostgreSQL via GoldenGate fails with invalid byte sequence for UTF8 error, how to overcome?
Hello colleagues. We did live up to attempts to organize replication from Oracle to Postgresql (for subsequent migration) and immediately received a fatal error.
When trying to upload data, the process crashes with the following error:
[Oracle][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR: invalid byte sequence for encoding "UTF8":0xc3
[Oracle][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]Failed transaction. The current transaction rolled back.
[Oracle][ODBC PostgreSQL Wire Protocol driver]String data, right truncated. Error in parameter 2.
Mapping problem with insert record (target format)...
*
id = 8
000000: 38 |8 |
title = landscape photography
000000: d0 bf d0 b5 d0 b9 d0 b7 d0 b0 d0 b6 d0 bd d0 b0 |................|
000010: d1 8f 20 d1 81 d1 8a d0 b5 d0 bc d0 ba d0 b0 |.. ............ |
Answer the question
In order to leave comments, you need to log in
Replica settings, version, odbc.ini?
IANAAppCodePage=106?
Did you read notes?
How To Replicate Data from Oracle to Postgres Using GoldenGate (Doc ID 1544137.1)
Character Conversion Issue When Replicating Data From Unicode Oracle To Unicode PostgreSQL (Doc ID 1543702.1
) .
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question