How to insert Arabic text via SQLCommand in SQL Server using C#

Question

Am using SQLCommand to make an insert query like following:

db.Database.SQLCommand("sql statement" , "pars");

but when i type Arabic (Unicode) text into the SQL statement it's only shows question marks in the database.

and when i do it as a database query in SQL Server management studio it works fine! please help

Is your database column type nvarchar? Did you try prefixing your value with N to signify it as unicode? Example: N'باالالا' — Filburt
– Filburt, Commented May 6, 2016 at 7:10
prefix n in sql datatypes tells to SQL Server I would like to store unicode text ,so you should modify text to ntext , varchar to nvarchar and so on — sepehr
– sepehr, Commented May 6, 2016 at 7:16
Please refer this - stackoverflow.com/questions/33912486/… — user5426326
– user5426326, Commented May 6, 2016 at 7:27

Zein Makki · Accepted Answer · 2016-05-06 07:17:07Z

2

You need to set the collation for you database to be arabic, and also that of the table column.

Also make sure the column is NVARCHAR and not VARCHAR

answered May 6, 2016 at 7:17

Zein Makki

30.2k6 gold badges58 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1