HSS HSS - 2 months ago 18
C# Question

Retrieve data from SQL in Marathi Language in C#

Please find the image of table
I am developing a windows application based using C#. I want to take input from user in Marathi language and save the same in SQL server database. Also retrieve the data from SQL server in Marathi language. I tried using following query but it didn't worked. So my question is how can I save and retrieve it as it is?

For example:

Select Company from Master_Item where Item_Name = 'मोबाईल'


You should use N before the value and the datatype should be nvarchar.

Select Company from Master_Item where Item_Name =  N'मोबाईल'

Source: http://www.codeproject.com/Questions/305931/Save-Hindi-Marthi-Content-in-Sql-Server-database