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?
Select Company from Master_Item where Item_Name = 'मोबाईल'
You should use
N before the value and the datatype should be
Select Company from Master_Item where Item_Name = N'मोबाईल'