MS SQL Server Interview Question:

What Are Binary String Data Types in MS SQL Server?

Submitted by: Administrator

Binary string data types are used to store binary strings. SQL Server 2005 supports the following binary string data types:

* BINARY - Binary strings with a fixed length of n bytes defined as BINARY(n). The maximum length is 8,000 bytes.
* VARBINARY - Binary strings with a variable length of n bytes defined as VARBINARY(n). The maximum length is 8,000 bytes. VARBINARY has a synonym of BINARY VARYING. VARBINARY also has special form as VARBINARY(MAX), which can store up to 2^31-1 bytes.
* IMAGE - Binary strings with a variable length up to 2^31-1 (2,147,483,647) bytes.

Submitted by: Administrator