1

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?

jehuty
  • 528
  • 1
  • 6
  • 20

1 Answers1

0

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

see a previous post

Community
  • 1
  • 1
Simmo
  • 3,101
  • 3
  • 16
  • 15
  • But if I can get the correct value in QueryAnalyzer with the column being varchar, should't the client get the same value? – jehuty Aug 18 '10 at 16:52