SQL Server Performance

what this N stand for in SQL Server.

Discussion in 'General Developer Questions' started by raj_id, Mar 29, 2004.

  1. raj_id New Member

    [?]what this N stand for in SQL Server and Why we need that.

    eg:
    DECLARE @query NVARCHAR(100)
    SET @query = N'SELECT * FROM '+ 'Shippers'

    plz email me at:krajeevs@yahoo.com
  2. satya Moderator

    When dealing with Unicode string constants in SQL Server you must precede all Unicode strings with a capital letter N, as documented in the SQL Server Books Online topic "Using Unicode Data". The "N" prefix stands for National Language in the SQL-92 standard, and must be uppercase. If you do not prefix a Unicode string constant with N, SQL Server will convert it to the non-Unicode code page of the current database before it uses the string.

    (in future kindly post your question in appropriate forum)

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page