SQL Server Arabic question mark

Question

I have Arabic data in the table but it is displayed as a question mark:

How I can resolve this problem?

Answer 1

Change the type of clientname nvarchar and the collation to Arabic_100_CI_AI, then in the insert query you have to add N before inserting the value, like in this example:

insert into table_name (...,clientname,..) values (...,N'محمد علي',....);

Answer 2

This is happening because the collation of your db doesn't support the language, whereas I think you're using varchar too. You have 2 possible solutions: The first one is to re-create your database with this encoding: SQL_LATIN1_General_CP1256_CI_AS (When creating db write your db name, and then go to options in the left sidebar then change the collation to the SQL Latin1 collation type". The second one is to change the column type from varchar(N) to nvarchar(N) I used the both scenarios and both worked for me.