How to prefix 'N' for the parameters in a store procedure for a unicode strings in c#, alternatively i am using the same procedure for the non unicode also. i need to append it only for the unicode ones kindly help.
views:
39answers:
1
+2
A:
You don't need to prefix N for parameters. This is only required for literals. Just make sure your stored procedure and ADO.NET parameters are of Unicode type (nvarchar or whatever).
Martin Smith
2010-10-13 10:31:33
thank you it worked i converted my parameters as nvarchars
skamale
2010-10-13 11:15:09