Cannot query nvarchar values

Question

I have one table in sql db where I store nvarchar values


    CREATE TABLE [dbo].[Buns]
    (
        [ID] INT NOT NULL PRIMARY KEY IDENTITY,
        
        [ARABIC] NVARCHAR(MAX) NULL, 
        [ENGLISH] NVARCHAR(MAX) NULL, 
        
    )

I can query the English values only

Appreciate your support with clear steps as am still a beginner

avoid screenshots , paste your sample code/data as text – eshirvana Jan 14 '22 at 11:20 — eshirvana, Jan 14 '22 at 11:20

score 1 · Accepted Answer · answered Jan 14 '22 at 11:24

1

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

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

answered Jan 14 '22 at 11:24

Richard Deeming

28,664
7
72
132

Thank you sir it worked – TT_MM Jan 14 '22 at 11:32

Cannot query nvarchar values

1 Answers1