I am trying to insert non English character in SQL from ASP.NET, but it is inserting N????
CREATE PROCEDURE [dbo].[client_billing_address_sp_update]
(
@in_type tinyint,
@vc_firstname_on_credit_card nvarchar(50) = ''
)
AS
IF(@in_type = 1)
BEGIN
INSERT INTO dbo.client_billing_address (vc_firstname_on_credit_card )
VALUES('N'+@vc_firstname_on_credit_card)
END
Why it is inserting N????
If I use the following statement it works:
insert into item (item_name) values(N'अंगूर')