Sunday, March 25, 2012

Collation confusion

I need transactional replication to replicate data between a database with a
collation of SQL_Latin1_General_CP1_CI_AS and another with
Latin1_General_BIN. Can this be done with any explicit conversion?
Reading the BOL and searching the internet yeilded no definitive answer.
Grant,
in the article preoprties (elipsis button) you will find the checkbox that
allows you to use the collation of the published column rather thanthe
default database collation on the subscriber.
HTH,
Paul Ibison
"Grant Marlow" <gmarlow@.yahoo.com> wrote in message
news:5aKXc.5738$ZC7.3697@.newssvr19.news.prodigy.co m...
> I need transactional replication to replicate data between a database with
a
> collation of SQL_Latin1_General_CP1_CI_AS and another with
> Latin1_General_BIN. Can this be done with any explicit conversion?
> Reading the BOL and searching the internet yeilded no definitive answer.
>

No comments:

Post a Comment