Common Data Types of SQL Server

Common Data Types in SQL Server:

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
A variable-length binary data with a maximum length of 2G +-1 (2,147,483,647) bytes

Text
ServerCodeThe maximum length of non-Unicode data in the Variable Length page is 2G + (2,147,483,647) characters. When the server code page uses double-byte characters, the storage volume is still 2,147,483,647 bytes. The storage size may be less than 2,147,483,647 bytes (depending on the string ).

Image
The variable-length binary data is between 0 and 2g + (2,147,483,647) bytes.

-- Binary and varbinary
Binary data type of a fixed length (Binary) or variable length (varbinary.

Binary [(n)]
A fixed length of n Bytes of binary data. N must be from 1 to 8,000. The storage space is n + 4 bytes.

Varbinary [(n)]
N Bytes of variable-length binary data. N must be from 1 to 8,000. The size of the bucket is the length of the actual input data plus 4 bytes, rather than n Bytes. The input data length may be 0 bytes. The synonym for varbinary in the SQL-92 is binary varying.
Note
1. If n is not specified in the data definition or variable declaration statement, the default length is 1. If n is not specified by the cast function, the default length is 30.
2. Use binary when the column data items are of the same size.
3. When the column data item sizes are inconsistent, use varbinary