When I was inserting and updating data over a SQL Server linked server connection, special characters in “strings” were altered.


A character “ë” was changed to the character “Ù”.


Now the first thing I checked was the collation on both databases and columns.

They were exactly the same, so I expected the data NOT to be altered.

I think this is a bug in SQL Server, but I have a workaround: set the collation of the linked server connection:


use master


exec sp_serveroption ’93_WGD’, ‘collation compatible’, ‘false’


exec sp_serveroption ’93_WGD’, ‘use remote collation’, ‘false’


exec sp_serveroption ’93_WGD’, ‘collation name’, ‘Latin1_General_BIN2’


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.