Differences between binary, varbinary, and image

Binary

A fixed-length binary data with a maximum length of 8,000 bytes.

Varbinary

A variable-length binary data with a maximum length of 8,000 bytes.

Image

Variable-length binary data. The maximum length is 2 ^ 31-1 (2,147,483,647) bytes.

The ntext, text, and image data types will be deleted in future versions of Microsoft SQL Server. Avoid using these data types in new development,
Consider modifying the applications that currently use these data types.Program. Use nvarchar (max), varchar (max), and varbinary (max ).

Unicode data with variable ntext length. The maximum length is 2 ^ 30-1 (1,073,741,823) characters. The storage size is twice the number of input characters (
In bytes ). Ntext SQL 2003 is synonymous with national text.
Text ServerCodeThe variable-length non-Unicode data in the page. The maximum length is 2 ^ 31-1 (2,147,483,647) characters. When the server code page is used
The storage is still 2,147,483,647 bytes. According to the string, the storage size may be less than 2,147,483,647 bytes.
The variable-length binary data of an image, ranging from 0 to 2 ^ 31-1 (2,147,483,647) bytes.