change ANSI to UTF-8 in sql

Question

I am trying to export data from excel sheet into sql server.There are some arablic field,am getting arabic value as "????" in my DB. Datatype for the column is nvarchar.Please Help

Answer 1

you should do something like this

use arabic collation or use unicode(nvarchar(max))

CREATE TABLE #t11
    (

    column1 NVARCHAR(100) 

    )
    INSERT INTO #t11 VALUES(N'لا أتكلم العربية')

    SELECT * FROM #t11

fiddle demo