Store Record In Gujarati Language In server server

Bhavesh Vankar

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

10 Replies

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

Darshan Shah6y ago
Accepted 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 Sahoo6y ago
Hi

One is nvarchar another is byte array
byte[] bytes = Encoding.Default.GetBytes(myString);
myString = Encoding.UTF8.GetString(bytes);
Thanks and regards
Bhavesh Vankar6y ago
its done we have to use nvarchar data type to store in other language.
Bhavesh Vankar6y ago
can be possible any demo ?
Darshan Shah6y ago
which version of SQL Server you are using?
Bhavesh Vankar6y ago
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 Shah6y ago
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 Vankar6y ago
its not working please suggest me another example please.
Varun Setia6y ago
Hi,

Use nvarchar
CREATE TABLE MyData(
..
nvarchar(100) gujarati_data
..
)
Jay Krishna Reddy6y ago
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,