My Oracle Support Banner

Special Characters Are Not Replicated In Golden Gate (Doc ID 2761724.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 12.3.0.1.4 and later
Information in this document applies to any platform.

Goal

On : 12.3.0.1.4 version,

Special characters are not replicated in Golden Gate


Special characters like ? are being converted to hexa characters like \xCC \x88 when being replicated. We are receiving input from Peoplesoft Database which is Oracle Exadata and Target is Windows SQL server. Please find the example below:
Source database Character set : AL32UTF8
Target database character set : windows-1252

Eg. If source description field is H?E?B, -HEB Whse Mgmt Implemen, in target we recieve H\xE2\x80\x91E\xE2\x80\x91B, -

Please let us know if we need to include any special character set in specific to this issue.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.