What does the capital "N" signify?

[Roy]

exec sp_dboption N'ACME', N'autoclose', N'false'

exec sp_dboption N'ACME', N'bulkcopy', N'false'

Hey all, as referenced above, this is code autogenerated by .NET. I've
noticed the "N" in some of the more advanced books online samples. What does
the capital "N" signify? What does it do? It always seems to precede a text
string, fwiw.

Just irks me because I have no clue what it's doing.

Thanks!

 

[Chris Hyde]

exec sp_dboption N'ACME', N'autoclose', N'false'

exec sp_dboption N'ACME', N'bulkcopy', N'false'

Hey all, as referenced above, this is code autogenerated by .NET. I've
noticed the "N" in some of the more advanced books online samples. What does
the capital "N" signify? What does it do? It always seems to precede a text
string, fwiw.

Just irks me because I have no clue what it's doing.

Thanks!

It basically means that the data is interpreted as an nvarchar datatype.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ea-ez_05ro.asp

HTH...

Chris