SQL Server中不同字符串类型之间的区别?

text ntext

• N
• var
• (max)

• CHAR(10)
• NVARCHAR(256)
• VARCHAR(MAX)

varchar(max) nvarchar(max)

in-row BLOB Table and Index Organization

CHAR VARCHAR NCHAR NVARCHAR NVARCHAR(MAX) String Functions TEXT NTEXT

UPDATE table SET column.WRITE(@value, @offset)

Row Compression Implementation

text ntext deprecated varchar(max) nvarchar(max)

N

Varchar

Char char

Text

Varchar(max) NVarchar(max)

http://msdn.microsoft.com/en-us/library/ms187752.aspx