Use of capital letter N in script

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Use of capital letter N in script

Author

Topic

Alexander Barnes
Starting Member

10 Posts

Posted - 2007-12-29 : 17:14:41

Below is from the SQL Help files on INSERT INTO
http://msdn2.microsoft.com/en-us/library/ms174335.aspx

What is the N doing in this script? (...N'F2'...N'Square Feet'...)

-----------------------------------------
USE AdventureWorks;
GO
INSERT INTO Production.UnitMeasure
VALUES (N'F2', N'Square Feet', GETDATE());
GO
-----------------------------------------

TIA.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-29 : 21:34:07

Means it's unicode string.