Cannot insert russian text into SQL server 2005 db

I'm using stored procedures and DataContext to insert data to SQL Server database (ASP.NET 4 + SQL Server 2005 database, GoDaddy hosting)

But after inserting russian text I see smth like this - '??????'

If I insert constant text I'm using following construction - N'russian_text' and it w开发者_如何学Corks fine.

Of course, I need to use variables as procedure parameters BUT I can't use it (for example - N@var fails)

ALTHOUGH I'm using N-type fields in tables (nvarchar etc.)

Does anybody knows where is mistake?

---

NVARCHAR variables are declared as

DECLARE @var NVARCHAR(100)
SET @var = N'unicode text'

and not as DECLARE N@var..., SET N@var

Same applies to procedure and function parameters

CREATE PROCEDURE InsertUnicodeData( @data NVARCHAR(200) ) AS
....

---

your SqlParamter variables in .net need to be of type SqlDbType.NVarChar.
as is now they're SqlDbType.VarChar.
in sql server your @text needs to be nvarchar(ColLength)