My SQL Server is dsplaying Unicode Characters.
Code:
declare @demo nvarchar(100)
set @demo = N'यह एक' 
select @demo
I want to insert Hindi in SQL from .Net, I am sending the Text "sonia"(IN ENGLISH) with N Before it.
Code:
cmd = new SqlCommand("INSERT INTO hindi(Name) VALUES (N'sonia')", con);
cmd.ExecuteNonQuery();

IN SQL, sonia is saved in english format only. I want the sonia to insert in HINDI FORMAT(सोनिया ) .. How its possible??

PLEASE HELP ME!!!