---
title: "Using BLOB DataTypes in SQL Server"  
description: "Blob Data TypeBLOB refers to large binary-valued image data. CLOB refers to large text data, and NCLOB refers to large ntext data.   Blob data is a fi"  
author: "Amit Singh"  
published: 2011-04-20  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/138/using-blob-datatypes-in-sql-server  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# Using BLOB DataTypes in SQL Server

##### Blob Data Type

BLOB refers to large binary-valued **[image](https://www.mindstick.com/articles/23551/an-investigate-distinctive-seafood-restaurant-for-your-image-stamp-character)** 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](https://www.mindstick.com/forum/161107/how-does-mongodb-handle-large-amounts-of-data-and-maintain-performance) per record. This data can be either in a text format or a [binary format](https://answers.mindstick.com/qa/51767/how-to-convert-a-number-into-binary-format).\
When working with blob [data in SQL](https://www.mindstick.com/articles/12937/how-to-import-excel-data-in-sql-server-2014) [Server](https://www.mindstick.com/articles/43769/what-is-serverless-architecture-is-it-worth-switching-over), the amount of data per record is typically well beyond the 8K of data that can fit within a single record.

We can [insert](https://www.mindstick.com/blog/173/executing-insert-delete-or-update-query-in-sqlserver-using-ado-dot-net) large amount data like image (in the binary format), [text file](https://www.mindstick.com/forum/2174/how-do-i-locate-a-particular-word-in-a-text-file) etc.

---

Original Source: https://www.mindstick.com/blog/138/using-blob-datatypes-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.