Knowledgebase

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

go

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

go

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

go

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

go