i am trying to pass a list of ids as a parameter of a stored procedure from vb.net. And these IDs can have unicode characters as well.
EXEC sp_IMS_RP_GetItemDetail @ItemID = '''736'', ''φ736'''
i am aware that if the parameter is defined as nvarchar it will go through. but once the parameter value gets into the stored procedure the unicode character gets converted and it wont go through for further querying. i was able to find out and tested as well that if i pass the parameter value by appending a N character before the value, the unicode character doesnt get converted.
EXEC sp_IMS_RP_GetItemDetail @ItemID = N'''736'', ''φ736'''
But i am failing to find a way to append a N character programmatically from vb.net.