Replication charset in oracle

From: Yossi Ben-Zvi <yossib_at_ncc.co.il>
Date: Thu, 25 Mar 1999 15:05:15 +0200
Message-ID: <7ddcfl$l84$1@news.netvision.net.il>

I'm using Oracle advanced multi master replication between two servers. The replication is set up and working with the same charecter set AMERICAN_AMERICA.WE8ISO8859P1
on both databases.

My problem is that I use more then one languages(E.g english and hebrew). our database is not using unicode. when the data to be replicated is in english every thing works fine.
However when the data to be replicated is in hebrew I have a problem. alltough the database recives the correct information, the replicated site recives junk instead.

This is a general question which I'm sure happens at any combination of languages and is not Hebrew spesifiec.

For what ever it's worth I add the following information: When I try to update the remote server using the Dblink every thing works fine.
I'm not very sure on how replication works but my guess is that, when \ where Oracle buffers transactions to be sent to the replicated site, some kind for file or catalog DB, does not support the correct charecter set.

Can anybody help??? Received on Thu Mar 25 1999 - 07:05:15 CST