We have a linked server (in SQL Server) that connects to Sybase database. We have also a job that transfer data from Sybase via the linked server and writes to a SQL Server database.
The problem is while transferring data from Sybase to SQL Server, it converts £ to œ. The SQL Server collation being used is SQL_Latin1_General_CP1_CI_AS.
I tried all possible server options in linked server properties such as Use Remote Collation, Collation Compatible etc. but no joy.
When I fetch the data through the Interactive SQL (that is Sybase tool), data is displayed properly.
I do not know what else I can do, please help.
It is code page issue as the guys stated above. I changed the collation that contains code page 850 which is same with sybase one and it is fixed.