Showing posts with label binary. Show all posts
Showing posts with label binary. Show all posts

Sunday, March 25, 2012

Difference between dataTypes in SQL 2005?

What is the difference between binary and image dataType.

When and how should I use them?Hello,

Here is difference between binary and image data type.
BINARY: Fixed-length binary data with a maximum length of 8,000 bytes
IMAGE: Variable-length binary data with a maximum length of 2^31 - 1 bytes

You can use them accordingly...