>>I have mugshot photos I want to store in a table along with the persons profile. Previously I have only stored the url to the photo so not sure what is the proper column type etc. I know there is an Image type, but is it that simple? I would love any advice for this or advice to not do it.
>
>The image data type has been superseded with varbinary(MAX) in SQL 2005 and later. SQL 2008 also introduced filestream data type which is more efficient for big image files. Check
http://coolthingoftheday.blogspot.com/2009/01/sql-server-varbinary-vs-filestream-code.htmlThanks Sergey,
Naomi provided a link to past messages where the recomendation appears to be store only a url in the database. In my case I am only needing an Avatar type field in the profile which may be a small jpg or mugshot to display; 215 pixels square at 72. I am not opposed to just storing a url as I have done that many times but thought I would progress to storing the image in the data. What do you think is the best idea for a overall strategy?
Thanks a bunch
Tim
Timothy Bryan