How to save Marathi/Hindi data into sql server 2008 from C#

Question

Hello friends I want to store marathi or hindi text(data) which is entered in textbox of windows C# application (that marathi Kiran or Shivaji Font is set to textbox's font - So user is able to type marathi text). & I am saving that in sql server 2008 database table as we save normal data entry even data is also inserted in that perticular field but it is in English words i.e It not showing marathi / Hindi Text in that column.. I had search lots of article for the same in those I found the column in which I want to store marathi or Hindi Text That columns should be nVarChar(Max) or nText.. I aslo didi that but Still I didn't get marathi text in that perticular column of table. PLEASE HELP..AS EARLY AS POSSIBLE..! THANKS..!

Nitin Sontakke · Answer

Could you please confirm that the fonts you are using are actually Unicode fonts?

Gnanavel Sekar · Answer

it's not datatype issue this issue comes for value (it's just cast issue) for that error see this https://blog.sqlauthority.com/2012/12/04/sql-server-fix-error-402-the-data-types-ntext-and-varchar-are-incompatible-in-the-equal-to-operator/ https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6bd4c661-ea0b-435f-af78-097e61549d41/using-equal-operator-in-transactsql-for-ntext-datatype-column?forum=transactsql http://karthikeyanbaskaran.blogspot.in/2013/05/error-message-402-data-types-ntext-and.html use nvarchar(max) it's the best approach if you want any reference visit below links http://www.dotnetawesome.com/2013/12/save-and-fetch-other-language-hindi-bangali-marathi-data-into-sql-server.html http://www.aspsnippets.com/Articles/Insert-Hindi-Marathi-Gujarati-Urdu-Persian-Arabic-Tamil-and-Telugu-languages-Text-characters-in-SQL-Server-using-C-and-VBNet.aspx http://www.aspsnippets.com/Articles/Insert-Hindi-Marathi-Gujarati-Urdu-Persian-Arabic-Tamil-Telugu-Chinese-and-Japanese-languages-Text-characters-in-SQL-Server.aspx http://dba.stackexchange.com/questions/25526/help-in-multi-language-medical-database http://sarojasp.blogspot.in/2014/01/save-data-in-sqlserver-database-in-any.html http://www.sqlerudition.com/how-to-store-non-english-unicode-characters-hindi-czech-arabic-etc-in-sql-server/ i think these links more enough..

prathamesh Thigale · Answer

I have tried you mentioned solution but it shows error in my C# project error are following The datatype ntext and nvarchar are incomplible in the equal to opreator. i am using sql server 2005 pls help me

Aniruddha Bhorkade · Answer

Hey Friends really nice solution for this problem thanks a lot... Rajput short but sweet suggestion i have search a lot on net but i got lengthy n not working solution my Marathi language store n fetch code is successful ...... Yeppy

Khargesh Rajput · Answer

use datatype ntext for column you want to store text