nvarchar (max) in SQL Server

In SQL Server, smaller data can be stored using varchar (n), nvarchar (n), and varbinary (n) types, storing large data, using varchar (max), nvarchar (max), and varbinary (max ) Instead of the text, ntext, and image data types.

which

varchar (max) instead of text;
nvarchar (max) instead of ntext;
varbinary (max) instead of image

The difference between ntext and nvarchar (MAX)

NTEXT

By default, ntext stores text data in the LOB structure, only pointers are stored in the table structure, and the pointer points to where the data is stored in the LOB.

NVARCHAR (MAX)

By default, no more than 8,000 bytes of data is stored directly in the table structure, and the data is stored in the LOB structure just like ntext.

Reference: nvarchar (max) http://www.studyofnet.com/news/902.html

This article is from the "Learning also leisure" blog, please be sure to keep this source http://studyofnet.blog.51cto.com/8142094/1692423

nvarchar (max) in SQL Server