SQL Server BLOB data types for accessing and storing data

October 1, 2007

[From SearchSQLServer]

BLOB data is a field that holds large amounts of data per record. This data can be either in a text format or a binary format. When working with BLOB data in SQL Server, the amount of data per record is typically well beyond the 8K of data that can fit within a single record.

There are various data types used for storing BLOB data and they've changed over time. The data types available for BLOB storage have been static for many years, but in SQL Server 2005, Microsoft introduced many new data types.

The article continues at http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1273934,00.html