Loading

How to create stored procedure to insert nvarchar data type?

Raghvendr Singh

14y6.9k

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anuja Pawar14y ago
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 Pawar14y ago
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 :)