> Dim cmd1 As New System.Data.SqlClient.SqlCommand("INSERT
> DomainTable (EmailID, Email, Domain) VALUES('2', 'איתי', 'לוז')",
[quoted text clipped - 3 lines]
> I have configured the Email and Domain field as nvarchar(50) which is
> supposed to take care of unicode.
As far as I understand it you should prefix the nvarchar string literals
with N e.g.
VALUES('2', N'לוז', N'איתי')
> However, I am not certain that the
> values are stored in the database as Hebrew. Any suggestions on how to
> do this?
Use SQL Server 2005 Management Studio Express and look at the table data.

Signature
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
Etayki - 18 Apr 2007 20:03 GMT
> > Dim cmd1 As New System.Data.SqlClient.SqlCommand("INSERT
> > DomainTable (EmailID, Email, Domain) VALUES('2', 'איתי', 'לוז')",
[quoted text clipped - 18 lines]
> Martin Honnen --- MVP XML
> http://JavaScript.FAQTs.com/
As far as I understand it you should prefix the nvarchar string
literals
with N e.g.
VALUES('2', N'לוז', N'איתי')
Yep, that did the trick - thanks there.