SQL use Unicode N in a Stored Procedure with variable
12,716
Use Nvarchar
data type in table's fields and stored procs parameters.
ADDED
See this link, maybe this will help you.
Author by
StevieB
Updated on June 04, 2022Comments
-
StevieB almost 2 years
I have the following Stored Procedure, Im looking for the correct syntax so I can play the Comments Value in the Comments column with N in front end the value for Unicode I need save Russian Characters Values
So at the moment the comments value is being passed as such
@comments
I want to do
N@comments but not working
ALTER PROCEDURE [dbo].[spInsertContactUs] ( @title VARCHAR(20) = default, @forename VARCHAR(100) = default, @surname VARCHAR(100) = default, @gender VARCHAR(50) = default, @address1 VARCHAR(100) = default, @address2 VARCHAR(100) = default, @city VARCHAR(50) = default, @county VARCHAR(50) = default, @country INT = default, @zipcode VARCHAR(50) = default, @email VARCHAR(200) = default, @comments NVARCHAR(MAX) = default, @mailinglist BIT = default, @address3 VARCHAR(100) = default, @dateOfBirth datetime = default ) AS SET NOCOUNT ON INSERT INTO tblContactUs ( dateAdded, title, forename, surname, gender, address1, address2, city, county, country, zipcode, email, comments, mailinglist, address3, dateOfBirth) VALUES ( getdate(), @title, @forename, @surname, @gender, @address1, @address2, @city, @county, @country, @zipcode, @email, @comments, @mailinglist, @address3, @dateOfBirth ) SET NOCOUNT OFF RETURN
;