ADO.NET + Sql Server Varchar encoding problem

Question

Put simply, I have a set of special characters in a Sql Server database varchar column, and I want to fetch it from a C# application.

Now the difficulty is: using Query Analyzer, I get the desired value of: "·°ï££".

However, through the client application, I end up with: "À░´úú".

It's a varchar column in a database with collation SQL_Latin1_General_CP850_CI_AI. In C#, I'm using default encoding. I'm at a loss - any ideas?

Answer 1

You need the column type changed to NVARCHAR to support unicode.

see a previous post