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.

Share:
12,716
StevieB
Author by

StevieB

Updated on June 04, 2022

Comments

  • StevieB
    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
    

    ;