SQL server image data

[John]

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

https://www.e-classifiedad.com

[Simon Hayes]

Re: SQL server image data


"John" <john@e-classifiedad.co m> wrote in message
news:b2e792c6.0 404212057.efa4e 44@posting.goog le.com...[color=blue]
> 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[/color]

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

[Google User]

Re: SQL server image data

To check the size of the image column use data_legnth(<co lname>). If
this column is the content of the file then the data_length(<co lname>)
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.co m (John) wrote in message news:<b2e792c6. 0404212057.efa4 e44@posting.goo gle.com>...[color=blue]
> 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[/color]