0

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

Charlieface
  • 52,284
  • 6
  • 19
  • 43
TT_MM
  • 3
  • 2

1 Answers1

1

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

SELECT ARABIC, JAPANESE, ENGLISH
FROM dbo.Buns
WHERE ARABIC = N'قيمة للبحث عنها'
Richard Deeming
  • 29,830
  • 10
  • 79
  • 151