Cannot query nvarchar values [duplicate]

To specify an nvarchar string literal, you need to prefix it with N:

SELECT ARABIC, JAPANESE, ENGLISH
FROM dbo.Buns
WHERE ARABIC = N'قيمة للبحث عنها'