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?
Manoj PatilPosted Jan 19, 2015, 1:43 AM
HanookPosted Nov 15, 2013, 6:31 AM
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
HanookPosted Nov 15, 2013, 6:26 AM