I am using SQL server 2000 with SP3 with SQL_Latin1_CP1_CS_AS as char set. I created linked servers to get data from sybase ASE ( sybase, we were using iso_1 char set and now we are changing it to cp850(in syabse).
We have some german characters in our sybase database.
After this char set change, when I try to get data from one of my views(with german characters), I dont get correct data rather I get some junk chars in place of those german chars.
If I use iso_1 for sybase, I get correct data.

In Linked server properties, I am setting remote collation to true.

Could you please help me out?