 Replication with different Character sets [message #118875] |
Mon, 09 May 2005 09:20  |
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  |
Frank Naude
Messages: 4590
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
