Store Record In Gujarati Language In server server

Question

i need to store data in sql server using c# web page. Record save successfully but when i see record in sql server it stored in like "????????" question mark how to show and store record in sql server in gujarati Language using asp.net c# web page. please help me as soon as possible

Darshan Shah · Answer

Try below of any option in your project. In Sql Server -> INSERT INTO table(fieldName) VALUES (N'??????') And In C# -> ViewData["Message"] = "N'??????'";

Laxmidhar Sahoo · Answer

Hi One is nvarchar another is byte array byte [] bytes = Encoding.Default.GetBytes(myString); myString = Encoding.UTF8.GetString(bytes); Thanks and regards

Bhavesh Vankar · Answer

its done we have to use nvarchar data type to store in other language.

Bhavesh Vankar · Answer

can be possible any demo ?

Darshan Shah · Answer

which version of SQL Server you are using?

Bhavesh Vankar · Answer

i have used nvarchar data type but when i store using c# web page and search data into table it show me like ???? in table. what process to store other language in sql server using c# web page.?

Darshan Shah · Answer

Content other than English you need to use nvarchar data type in your database table to store Unicode data or character. Something about nvarchar datatype. It is a variable that has length data type. Use to store Unicode characters means other than English. And it occupy 2 bytes of space for each character.

Bhavesh Vankar · Answer

its not working please suggest me another example please.

Varun Setia · Answer

Hi, Use nvarchar CREATE TABLE MyData( .. nvarchar(100) gujarati_data .. )

Jay Krishna Reddy · Answer

Hope the below link solves your problem. http://www.sqlerudition.com/how-to-store-non-english-unicode-characters-hindi-czech-arabic-etc-in-sql-server/ Thanks,