dbTalk Databases Forums  

Replicating double quotation marks to heterogenous subscribers

microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication


Discuss Replicating double quotation marks to heterogenous subscribers in the microsoft.public.sqlserver.replication forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rich Doyle
 
Posts: n/a

Default Replicating double quotation marks to heterogenous subscribers - 11-10-2004 , 09:48 AM






I am currently attempting to replicate data from a SQL Server 2000 database
to an Oracle database using transactional replication. All works fine with
the exception that when I attempt to replicate data which contains double
quotations, it is somehow stripped out by the time it reaches the subscriber.
I've tried toggling the quoted identifiers option and have also used various
ODBC and OLE DB drivers but to no effect. Can anyone help with this issue?
Thanks in advance!!

Reply With Quote
  #2  
Old   
Rich Doyle
 
Posts: n/a

Default RE: Replicating double quotation marks to heterogenous subscribers - 11-17-2004 , 10:33 AM






Ok then...plot thickens!
Replication works when it takes the initial snapshot of the data. Problems
occur when data is modified. Blank spaces appear where I'd expect the double
quotations to be! Any ideas??

"Rich Doyle" wrote:

Quote:
I am currently attempting to replicate data from a SQL Server 2000 database
to an Oracle database using transactional replication. All works fine with
the exception that when I attempt to replicate data which contains double
quotations, it is somehow stripped out by the time it reaches the subscriber.
I've tried toggling the quoted identifiers option and have also used various
ODBC and OLE DB drivers but to no effect. Can anyone help with this issue?
Thanks in advance!!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.