Why can I not import arabic csv file into SQL Server? -

i have arabic .csv file on pc, , want import file sql server, when import it, error:

text truncated or 1 or more characters had no match in target code page

what happened?

for storing data other english language arabic, hindi etc, need nvarchar(max) or nchar(max), instead of varchar(max).

below example shows difference between varchar , nvarchar

create table tab (remark varchar(max)  ); insert tab values('this test');  create table tab_arabic (remark nvarchar(max)  ); insert tab_arabic values(n'هذا هو الاختبار');