in the below statement, what does N mean?

• winston Smith

  SSCoach

  Points: 19500

  More actions

  April 17, 2007 at 8:13 am

  #175861

  I know that in the below statement the sproc disables replication on the database ReplTesting, but I want to know what the N charachter does infront of the parameters, as i have run it with and without the N and it seems to run ok either way.

  exec

  sp_replicationdboption @dbname = 'ReplTesting'

  ,

  @optname = N'publish'

  ,

  @value = N'false'

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 17, 2007 at 8:18 am

  #700926

  The N in front of a string constant, like N'false', simply indicates that the string is converted into Unicode (nchar or nvarchar data types.