SQL Tutorial: Binary Data Types

Data Type Description
binary

Maximum length of 8,000 bytes

varbinary

Maximum length of 8,000 bytes

varbinary(max)

 

max indicates that the maximum storage size is 2^31-1 bytes (2 GB)

image

Maximum length of 2,147,483,647 bytes.