how to insert unicode text to SQL Server from query window

Question

I'm using the following code:

INSERT INTO tForeignLanguage ([Name]) VALUES ('Араб')

this value inserted like this '????'

How do I insert unicode text from the sql management studio query window?

Answer 1

The following should work, N indicates a "Unicode constant string" in MSSQL:

INSERT INTO tForeignLanguage ([Name]) VALUES (N'Араб')