Inserting hebrew values in SQL Server 2008

问题:

I've been trying to update a record with hebrew texy into a DB table, and it shown as "??????". Here's my command:

UPDATE HebrewTbl
   SET HebrewVal = N'ראשונה'
 WHERE Id = 1
GO

All solutions I found over the Internet ended up in adding that N in the beginning, but in my case the problem continues.

Please advise. Thanks in advance

回答1:

Copied from comment so question can be set to answered per suggestion of this post.

Set your column to nvarchar and have the correct collation enabled to allow Hebrew characters.