Click to See Complete Forum and Search --> : About length of an image dataype in SQL server 2000


Mushq
November 30th, 2007, 12:37 AM
I am using SQL Server 2000 Version 8.00.194.
On creating the image data type in a table SQL server shows me image's default size is "16" and further more it doesn’t allow me to change that size.
Can anyone please tell me what does length of an image data type means and what is meant by default length "16", and why it doesn’t allow me to change?

Best Regards,
Mushq

hspc
December 2nd, 2007, 02:16 PM
Image Size can store up to 2GB of data.
The 16 byte size you see is just an inline pointer to where the image data is stored.
Image and Text data are not stored within the record data, they have different structure inside the database data files.

Shuja Ali
December 3rd, 2007, 03:55 AM
And in case you need to find the length of the actual data stored, you can use DataLenght function.