Save and Retrieve data from Sql in Marathi Language

Question

how to create Save and Retrieve data from Sql in Marathi Language

I am going to design a application having front end with C#.Net and Back end with SQL SERVER in. And I want the complete interface of that application in marathi, English and Hindi language.

when I enter the marathi character in data base and execute it, it shows "????????" like this.
What I do to enter and store the marathi character in Database?

Hanook · Answer

two things you should consider while storing other languages data to database in SQL server 1) You should precede N to the string 2) The data type must be NVARCHAR --Script to be run on SQL server Management Studio. check the output DECLARE @InCorrect NVARCHAR(100) = '????????????' SELECT @ InCorrect Incorrect GO DECLARE @Correct NVARCHAR(100) = N'????????????' SELECT @Correct Correct OUTPUT: Incorrect ???????????? Correct ?????????? Reference: http://social.technet.microsoft.com/Forums/sqlserver/en-US/1c32afb3-8e6d-4df2-9b97-b8951cf33b25/how-to-store-marathi-character-in-sql-server?forum=sqltools

Manoj Patil · Answer

Thanks Hanook. Your solution is working for me.

Hanook · Answer

What is the datatype of column where you are storing marathi chars?