blog

Home / DeveloperSection / Blogs / Using BLOB DataTypes in SQL Server

Using BLOB DataTypes in SQL Server

Amit Singh3513 20-Apr-2011
Blob Data Type

BLOB refers to large binary-valued image data. CLOB refers to large text data, and NCLOB refers to large ntext data.
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.

We can insert large amount data like image (in the binary format), text file etc.


Updated 18-Sep-2014

Leave Comment

Comments

Liked By