Console.WriteLine Hebrew

[Etayki]

Hi!

I am trying to print Hebrew characters:

Module Module1

Sub Main()

Console.WriteLine("�יתי")

End Sub

End Module

And the output is:

????

How can I print in Hebrew to the console window?
Question number 2:

I am trying to insert data in Hebrew into my database:

Dim conn As New System.Data.SqlClient.SqlConnection()
conn.ConnectionString = "DataSource=.
\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Datab ase2.mdf;Integrated
Security=True;User Instance=True"
conn.Open()
Dim cmd1 As New System.Data.SqlClient.SqlCommand("INSERT
DomainTable (EmailID, Email, Domain) VALUES('2', '�יתי', 'לוז')",
conn)
cmd1.ExecuteNonQuery()
I have configured the Email and Domain field as nvarchar(50) which is
supposed to take care of unicode. However, I am not certain that the
values are stored in the database as Hebrew. Any suggestions on how to
do this?

Thanks in advance,

Etay

[Martin Honnen]

Etayki wrote:

Dim cmd1 As New System.Data.SqlClient.SqlCommand("INSERT
DomainTable (EmailID, Email, Domain) VALUES('2', '�יתי', 'לוז')",
conn)
cmd1.ExecuteNonQuery()
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.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Etayki]

On Apr 18, 5:42 pm, Martin Honnen <[e-mail]:

Etayki wrote:

Dim cmd1 As New System.Data.SqlClient.SqlCommand("INSERT
DomainTable (EmailID, Email, Domain) VALUES('2', '�יתי', 'לוז')",
conn)
cmd1.ExecuteNonQuery()

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.

--

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.