Home » Server Options » Replication » Character Set Issue (SQL Server 2008 R2 on Windows 2008 Server and Oracle 11g r2 on linux)
Character Set Issue [message #619581] Wed, 23 July 2014 10:11 Go to next message
Messages: 20
Registered: June 2014
Location: Dark Saturn
Junior Member

Please refer Note "GoldenGate and Character Set Issues (Doc ID 1900380.1)"

It mentions


However, one thing you need consider is that WE8ISO8859P1 is a superset of AL32UTF8. There will be no problems replicating from WE8ISO8859P1 into AL32UTF8 . However, there will be problems when doing the opposite, as there are characters in AL32UTF8 that don't exist in WE8ISO8859P1

My query is, if WE8ISO8859P1 is the superset of AL32UTF8, in fact there might be problem in replicating from WE8ISO8859P1 into AL32UTF8; As AL32UTF8 might not have some characters which WE8ISO8859P1 do have!

And Suppose if my understanding is wrong then as per the Metalink note I shall not get following warning I am getting now


WARNING OGG-03504 NLS_LANG character set AL32UTF8 on the target is different from the source database character set WE8MSWIN1252. Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set

Thanks and Regards
Re: Character Set Issue [message #619582 is a reply to message #619581] Wed, 23 July 2014 10:14 Go to previous message
Messages: 26757
Registered: January 2009
Location: SoCal
Senior Member
>one thing you need consider is that WE8ISO8859P1 is a superset of AL32UTF8
simple documentation error which should read as below:
, one thing you need consider is that WE8ISO8859P1 is a subset of AL32UTF8
Previous Topic: Is it possible to parallelise Initial Load in Golden Gate?
Next Topic: (Error (-4) retrieving key) during Golden Gate Password Encryption
Goto Forum:

Current Time: Mon Jan 18 11:57:52 CST 2021