SQL Server BLOB data types for accessing and storing data

Monday Oct 1st 2007 by DatabaseJournal.com Staff
Share:

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.

[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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved