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:
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’