Preceding "N" character in SQL syntax

• Grinja

  Hall of Fame

  Points: 3590

  More actions

  January 7, 2010 at 3:34 am

  #215462

  Hi,

  In some texts i find the character "N" preceding a string and was wondering what the significance was.

  For example in this code:

  SELECT CustomerID

  FROM Customer

  WHERE Country = N'Spain'

  Thanks,

  G

• tyson.price

  SSCrazy

  Points: 2093

  More actions

  January 7, 2010 at 3:58 am

  #1100094

  I think it has to do with using Unicode formatting.

• Nabha

  SSCrazy Eights

  Points: 8534

  More actions

  January 7, 2010 at 4:21 am

  #1100103

  Just to add to what tyson had to say,

  BOL

  Unicode strings

  Unicode strings have a format similar to character strings but are preceded by an N identifier (N stands for National Language in the SQL-92 standard). The N prefix must be uppercase. For example, 'Michél' is a character constant while N'Michél' is a Unicode constant. Unicode constants are interpreted as Unicode data, and are not evaluated by using a code page. Unicode constants do have a collation. This collation primarily controls comparisons and case sensitivity. Unicode constants are assigned the default collation of the current database, unless the COLLATE clause is used to specify a collation. Unicode data is stored by using 2 bytes per character instead of 1 byte per character for character data. For more information, see Using Unicode Data.

  Unicode string constants support enhanced collations.

  http://support.microsoft.com/kb/239530

  ---------------------------------------------------------------------------------

• Grinja

  Hall of Fame

  Points: 3590

  More actions

  January 7, 2010 at 7:48 am

  #1100224

  Cool thanks for the feedback, it's been bugging me for a while