Hi! Guys,
May be this question is little stupid but I want to clarify this.
Let suppose I have image data field in Sql server 2000 and I am uploading
an image of 10KB(thru asp.net application).
What would be the size for that table with image data field ?
Is it 10KB or less than 10KB or more than 10KB ?

Thanks
John
www.e-classifiedad.com

"John" <john@e-classifiedad.com> wrote in message
news:b2e792c6.0404212057.efa4e44@posting.google.co m...
> Hi! Guys,
> May be this question is little stupid but I want to clarify this.
> Let suppose I have image data field in Sql server 2000 and I am uploading
> an image of 10KB(thru asp.net application).
> What would be the size for that table with image data field ?
> Is it 10KB or less than 10KB or more than 10KB ?
>
> Thanks
> John
> www.e-classifiedad.com

Greater than 10KB, because there will be some table metadata (and I'm
assuming you have other columns in the table also). And possibly a lot more,
if you include any indexes on other columns.

Simon

To check the size of the image column use data_legnth(<colname>). If
this column is the content of the file then the data_length(<colname>)
should be same as file size. The winodws explorer rounds the size upto
the nearest KB. You can click on the file properties to see the actual
bytes. Hope this helps.

Thanks
john@e-classifiedad.com (John) wrote in message news:<b2e792c6.0404212057.efa4e44@posting.google.c om>...
> Hi! Guys,
> May be this question is little stupid but I want to clarify this.
> Let suppose I have image data field in Sql server 2000 and I am uploading
> an image of 10KB(thru asp.net application).
> What would be the size for that table with image data field ?
> Is it 10KB or less than 10KB or more than 10KB ?
>
> Thanks
> John
> www.e-classifiedad.com