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

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

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

KB101297

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

Answer:

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.


Comments

0 Comments.
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
9825
Since 8/13/2008
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


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