I.T. Discussion Community!
-Collapse +Expand
Search DBA Group:

-Collapse +Expand DBA Store

Prestwood eMagazine

November 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 11 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 = P1193A1
Enter key:
FAQ Contributed By Stephen Berry:
Visit Profile

 KB Article #101297 Counter
Since 8/13/2008

Follow PrestwoodBoards on: 

©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech