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
Messages: 1
Registered: May 2005
Junior Member
Hi folks!

I have got the following replication environment:

master site:

updatable materialized view (snapshot) site:

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

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: 4426
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.

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

Current Time: Tue Oct 13 18:50:29 CDT 2015

Total time taken to generate the page: 0.06599 seconds