Your full service technology partner! 
-Collapse +Expand
Search DBA Group:

-Collapse +Expand DBA Store

Prestwood eMagazine

September Edition
Subscribe now! It's Free!
Enter your email:

   ► KBSQL ServersMicrosoft SQ...MS SQL 2005   Print This     
  From the October 2015 Issue of Prestwood eMag
DBA MS SQL 2005:
MS-SQL Binary Large Objects
Posted 13 years ago on 8/13/2008 and updated 9/19/2008
DBA Q&A Flashcard:
 A flashcard from our DBA Flashcards Library
 A FAQ from our DBA FAQ Page


Question: How do you store BLOBs (Binary Large Objects) in Microsoft SQL Server?


BLOBs (Binary Large Objects) are collections of data that can be stored as a single entity in a database. In Microsoft SQL Server, BLOBs are stored using the text, ntext, and image data types.

  • The text data type stores a variable length of non-unicode data up to 231 - 1 characters.
  • The ntext data type stores a variable length of unicode data up to 230 - 1 characters. The storage size, in bytes, is twice the amount of characters.
  • The image data type is used to store image files smaller than 231 - 1 bytes.


Share a thought or comment...
Write a Comment...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1272A1
Enter key:
FAQ Contributed By Stephen Berry:
Visit Profile

 KB Article #101297 Counter
Since 8/13/2008
Sales Website: Or visit our legacy sales site:

©1995-2021 Prestwood IT Solutions.   [Security & Privacy]