What is that N for

• Sylvain Coutu

  Ten Centuries

  Points: 1077

  More actions

  July 9, 2004 at 12:18 pm

  #108495

  Hi,

  I am wondering what is that N doing in front of a varchar

  DECLARE @myVar VARCHAR(50)

  SET @myVar = N'a String'

  Thanks

  

• Peter P

  SSCrazy

  Points: 2777

  More actions

  July 9, 2004 at 12:39 pm

  #514164

  Unicode constants are specified with a leading N: N'A Unicode string'.

  Unicode supports a wider range of characters