Last Updated: February 25, 2016
· themusyo

Put arabic and persian words in sql server 2008 dynamicaly

If you ever tried to put arabic or persian words in your table columns through code behind(not the visual table editor) you know that what you actually get is some question marks instead. e.g if you try to put "سلام" in your table, what you get is: "????"
to fix the problem you should put an "N" (without the qoutations) before each persian or arabic string you try to add to your table.
INSERT INTO mytable(text, name) Values(N'سلام', N'علی موسوی')"