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

Sachin Devkar

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..!

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Could you please confirm that the fonts you are using are actually Unicode fonts?
Gnanavel Sekar9y ago
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 Thigale9y ago
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 Bhorkade11y ago
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 Rajput11y ago
use datatype ntext for column you want to store text