Users Pricing

blog

Home Blogs Using BLOB DataTypes in SQL Server – MindStick

Using BLOB DataTypes in SQL Server

Amit Singh 4132 20 Apr 2011 Updated 18 Sep 2014
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.


Amit Singh

Other


1 Comments


Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md