开发者

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)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜