SQL Server in front plus n explanation

from: http://lzde360.blog.163.com/blog/static/6780720820111026112033917/

Plus N represents storage in Unicode format when stored in a database.  N ' string ' means string is a Unicode string    The format of a Unicode string is similar to a normal string, but preceded by an n identifier (n stands for the International language (national Language) in the SQL-92 standard). The N prefix must be uppercase. For example, ' Michél ' is a string constant and N ' Michél ' is a Unicode constant. Unicode constants are interpreted as Unicode data and are not evaluated using code pages. Unicode constants do have collations that are primarily used to control comparisons and case sensitivity. Assigns the default collation of the current database to a Unicode constant unless the collation is specified with the COLLATE clause. Each character in the Unicode data is stored using two bytes, and each character in the character data is stored with one byte. For more information, see Working with Unicode data.    Unicode string constants support enhanced collations.

----------------->>>