is an abbreviation for variable-length character string. It is a string
of text characters that can be as large as the page size for the
database table holding the column in question. The size for a table page
is 8,196 bytes, and no one row in a table can be more than 8,060
characters. This in turn limits the maximum size of a VARCHAR to 8,000
The N in NVARCHAR means uNicode. Essentially, NVARCHAR is nothing more
than a VARCHAR that supports two-byte characters.
The most common use
for this sort of thing is to store character data that is a mixture of
English and non-English symbols - in my case, English and Japanese.
Hope you got it now