How to create stored procedure to insert nvarchar data type?

Question

Hello friends!
I want to insert nvarchar data type through Storedprocedure such as hindi,chiniese etc.
For example:
Insert into Users(Test)Values(N'some charactors'). This query is working fine but I am unable to do this through stored procedure.

Anuja Pawar · Answer

Refer this article Hope it works for you. Good luck :) http://www.eggheadcafe.com/microsoft/SQL-Server/30819858/pass-unicode-to-stored-procedures.aspx

Anuja Pawar · Answer

Refer this threads http://stackoverflow.com/questions/923876/why-are-my-chinese-characters-not-displayed-correctly-in-c-sharp-string http://stackoverflow.com/questions/5970309/pass-japanese-characters-to-a-sql-server-stored-procedure Hope it helps :)