SQL Server T-SQL - Arabic format not able to insert directly, but when inserted through c# it works

Question

declare @OfferNameArabic nvarchar(100) = cast(' كوب' as nvarchar(100))
select @OfferNameArabic

set @OfferNameArabic =' كوب'
select @OfferNameArabic

When inserted through c#

When inserted through query

Answer 1

You need to use N before string literal:

declare @OfferNameArabic nvarchar(100)=N' كوب'; 
select @OfferNameArabic;

db<>fiddle demo