469,081 Members | 1,792 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

SQL server image data

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
Jul 20 '05 #1
2 4895

"John" <jo**@e-classifiedad.com> wrote in message
news:b2*************************@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
Jul 20 '05 #2
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
jo**@e-classifiedad.com (John) wrote in message news:<b2*************************@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

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by lucifer | last post: by
2 posts views Thread by lucifer | last post: by
18 posts views Thread by UJ | last post: by
7 posts views Thread by Sirplaya | last post: by
2 posts views Thread by Connie | last post: by
76 posts views Thread by rcoco | last post: by
9 posts views Thread by FAQ server | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.