MSSQL 2010 Inserting Cyrrilics

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!

You may also like...