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
chetankumar
Messages: 20
Registered: June 2014
Location: Dark Saturn
Junior Member
Hello

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

It mentions

Quote:

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

Quote:

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
Chetan
Re: Character Set Issue [message #619582 is a reply to message #619581] Wed, 23 July 2014 10:14 Go to previous message
BlackSwan
Messages: 25716
Registered: January 2009
Location: SoCal
Senior Member
>one thing you need consider is that WE8ISO8859P1 is a superset of AL32UTF8
WRONG!
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 Nov 20 18:44:29 CST 2017

Total time taken to generate the page: 0.02914 seconds