Insert Hindi text in sql server or Save Hindi, Marathi Content in Sql Server database or How to store Hindi data in sql server 2005 or Data saving in Hindi in sql server 2008

Step 1:- Create Temp table

CREATE TABLE #PlanetOrderList

(

       ID INT IDENTITY,

       HindiName VARCHAR(50),

       EnglishName VARCHAR(50),

       RomanName VARCHAR(50),

)

Step 2:- Insert record in table

INSERT INTO #PlanetOrderList(HindiName,EnglishName,RomanName)

VALUES ('सूर्य','Sun','Surya'),

       ('बुध','Mercury','Budha'),

       ('शुक्र','Venus','Sukra'),

       ('पृथ्वी','Earth','Prithvi'),

       ('मंगल','Mars','Mangal'),

       ('बृहस्पति','Jupitar','Brahspati'),

       ('शनि','Saturn','Shani'),

       ('अरुण','Uranus','Arun'),

       ('वरूण','Neptune','Varun'),

       ('यम','Pluto','Yam')

Step 3:- Result

Note:-

Here HindiName column record showing?????

How to solve?

Step 4:- Change the data type of the column (HindiName) to NVARCHAR (50) or NTEXT Instead of VARCHAR (50)

CREATE TABLE #PlanetOrderList

(

       ID INT IDENTITY,

       HindiName NVARCHAR(50),

       EnglishName VARCHAR(50),

       RomanName VARCHAR(50),

)

Step 5:- Append "N" before the string name

INSERT INTO #PlanetOrderList(HindiName,EnglishName,RomanName)

VALUES (N'सूर्य','Sun','Surya'),

       (N'बुध','Mercury','Budha'),

       (N'शुक्र','Venus','Sukra'),

       (N'पृथ्वी','Earth','Prithvi'),

       (N'मंगल','Mars','Mangal'),

       (N'बृहस्पति','Jupitar','Brahspati'),

       (N'शनि','Saturn','Shani'),

       (N'अरुण','Uranus','Arun'),

       (N'वरूण','Neptune','Varun'),

       (N'यम','Pluto','Yam')

Step 6:- Result