I did face an interesting problem today.
I have MS SQL server 2010 and I wanted to insert Cyrillics alphabet in it. The type of the field is nvarchar but when i insert data the data was looking like ‘???? ??? ???’.
The answer is here. http://forums.asp.net/t/1164650.aspx/1/10
You can make a query containing the N parameter before it like this:
string sql = “insert into Comments values(1 , N’садасдасдасдас’);
and everything is ok now!