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?

question from:https://stackoverflow.com/questions/1350968/how-to-insert-unicode-text-to-sql-server-from-query-window

Answer 1

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

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