OraFAQ Forum: Replication » Character Set Issue

Home » Server Options » Replication » Character Set Issue (SQL Server 2008 R2 on Windows 2008 Server and Oracle 11g r2 on linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Character Set Issue [message #619581]

Wed, 23 July 2014 10:11

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

Report message to a moderator

Re: Character Set Issue [message #619582 is a reply to message #619581]

Wed, 23 July 2014 10:14

BlackSwan
Messages: 26766
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 22 12:31:32 CST 2026