Home » Server Options » Replication » Replication with different Character sets
icon9.gif  Replication with different Character sets [message #118875] Mon, 09 May 2005 09:20 Go to next message
HannesFroehn
Messages: 1
Registered: May 2005
Junior Member
Hi folks!

I have got the following replication environment:

master site:
-Oracle 9.2.0.5.0
-NLS_CHARACTERSET = UTF8
-NLS_NCHAR_CHARACTERSET = UTF8

updatable materialized view (snapshot) site:
-Oracle 9.2.0.5.0
-NLS_CHARACTERSET = WE8ISO8859P1
-NLS_NCHAR_CHARACTERSET = UTF8

Is it possible to replicate a NVARCHAR2 field of the materialized view site with an VARCHAR2 field of the master site?
Both fields should contain UTF8 coded text, don't they!?

Thanks for your help

Hannes
Re: Replication with different Character sets [message #118903 is a reply to message #118875] Mon, 09 May 2005 10:53 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Should work -

"Unicode is supported in both multimaster and materialized view replication environments. In Oracle9i or higher, all columns specified as NCHAR or NVARCHAR2 datatype are stored in Unicode format."

Source: Appendix B of the Database Advanced Replication Guide.

Best regards.

Frank
Previous Topic: OID sync with openLDAP.. POSSIBLE??
Next Topic: problem in refrehing materialized view
Goto Forum:
  


Current Time: Thu Mar 28 05:58:34 CDT 2024