Oracle to SQL Replication charsets

[ptheriault]

Currently I am replicating data from an Oracle instance to my SQL Server instance. I am having a problem with a few talbles. I think it is because the char set are different on those tables. Is there a way to change the char set in the replication as it comes over from Oracle?

 

[mrdenny]

How are you replicating the data from Oracle to SQL?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ptheriault]

I'm using transactional replication. The publisher is the the oracle server and the subscriber is the SQL server. It was set up by a vendor before I started here. all the tables work except for one. That one uses different char sets. I believe it is a EUROPEAN charset. I am using nvarchar on my SQL server and I thought that would correct the problem but it didn't.

--- Paul
-- The Database server looks fine, it must be the Network!

 

[mrdenny]

You will probably need to play around with the collation of the columns of the tables when they get created on the SQL Server side.

If a vendor setup the replication make them come and fix it.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ptheriault]

Thanks Denny,
I have tossed this back on the vendor. I researched it as much as possible and found that it was indeed the charsets. They are going to have to correct it.

- Paul
- Database performance looks fine, it must be the Network!