Replication data corruption

Last Post 25 Jul 2006 05:43 AM by cchitanu. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
cchitanu
New Member
New Member

--
25 Jul 2006 05:43 AM
Here is my problem : from time to time the data on a table used in replication is getting corrupted at the subscriber(transactional replication, push subscription) : character like Ó is copied as O.

Both publisher and subscriber database, tables have the same collation : SQL_Latin1_CP850_CI_AS, however subscription server has a different collation : SQL_Latin1_General_CP1_CI_AS. A fix we found : if we delete and re-insert the row at the publisher this time the data is transferred fine by the replication.

Any idea ?

Thanks
Cristian
You are not authorized to post a reply.

Acceptable Use Policy