SQL 2008 R2 Replication with database/table collation change

• Muhanned Maayeh-445298

  SSC Eights!

  Points: 986

  More actions

  September 4, 2013 at 4:44 am

  #281963

  I have a transactional replication setup with a database with a collation of Arabic_CS_AS however, when setting up the subscriber the collation is the standard SQL_Latin1_General_CP1_CI_AS collation. The affect is that certain columns in the database are now garabage characters.

  Is there a way to modify the subscriber database collation as the publication?