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'Араб') 

Answer 2

The perfect solution with data type limitation:

Basically in MS-SQL Server Amharic text not working properly when the column datatype is 'text'.Therefore to put Amharic text on column with datatype text, first change the text datatype to 'nvarchar(MAX)' or just 'nvarchar' with any char length that MS-SQL Server supported.