How do you declare a variable with BLOB as datatype? How can you use BLOB data type? What size can be given to its variable?

Questions by madhug56   answers by madhug56

Showing Answers 1 - 1 of 1 Answers

intelmental4

  • Jul 23rd, 2007
 

BLOB is Binary Large Object

When you declare any variable as image, text, ntext ... they would be BLOB data types

Text = 2^31-1
text = 2^30-1
ntext = 2^31-1

-Each text, ntext, image colum can in a table can contain upto 2 GB of BLOB data
-Blob data is stored seperately in a collection of 8 kb data pages

Mostly the location to the BLOB data is stored in SQL, not the data itself if the 'text in row option' is not enable explicitly

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions