saving and retrieving image data

[Rashid_Mehmood]

Hi All, I'm working on a c# application that suppose to store and retrieve images in the sql server database. By choosing a column of type image, it's size is defaulted to 16bytes but images usually are larger than that. How can I increase the size of an image column so that it can hold images of some 10+kb? Plz answer and oblige. Thanks

[Colin Angus Mackay]

Rashid_Mehmood wrote: it's size is defaulted to 16bytes That is the size of the pointer to the image, not the image.

---

Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

[Mike Dimmick]

An image column can hold up to 2GB of data, IIRC. As Colin says, the 16 byte value is the pointer to where the data actually lives. Image data is not held on the same data page as the rest of the row - you should be aware that more I/O will occur if you use text, ntext or image columns. Having said that SQL Server has a feature 'text in row' which allows you to specify that up to a certain amount of data will be placed in the row itself, not on separate pages. Stability. What an interesting concept. -- Chris Maunder

[Mr Cooper]

As a work around u can save the path to the images which will reduce the size of the db and also reduces the effort to handle images in sql. i hope this helps.