What does N' stand for ? - SQL Server Forums

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

SQL Server 2005 Forums

Transact-SQL (2005)

What does N' stand for ?

Author

Topic

missMac
Posting Yak Master

124 Posts

Posted - 2008-10-21 : 08:06:18

Hello,
What does N stand for in a statement like

select @s = N'statement goes here '

thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-21 : 08:08:36

N stands for unicode.unicode is usually used for storing multiple language data. in this each character takes twice the storage as normal character data.

PeterNeo
Constraint Violating Yak Guru

357 Posts

Posted - 2008-10-21 : 08:08:46

From BOL(Server-Side Programming with Unicode )
To make a database Unicode-aware involves defining Unicode-aware client interactions in addition to using the nchar, nvarchar, and ntext data types to define Unicode storage. You can define Unicode-aware client interactions by performing the following on the database server side:

Prefix Unicode character string constants with the letter N.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources