>>>>I have mugshot photos I want to store in a datatable 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.
>>>>Thanks
>>>>Tim
>>>
>>>The problem was discussed here before. If you do want to store this data in a table, then use varbinary(max) data type.
>>
>>Hi Naomi,
>>
>>Thanks for the quick response. Why that instead of Image? Just curious. Also, how might I be able to save a photo in the table in one of my records for testing? I can't just cut and paste it in like other text.
>>Tim
>
>See also http://forums.asp.net/p/1096999/1658599.aspx

Thanks for all the great links Naomi,
It is appearing the best solution is probably to just store the url like I have done in the past. I am going to continue to read these items and do some testing so I know the process while I am on it. I will change my column type away from image also as I don't want to learn something that isn't staying around.
Thanks again
Tim