>>>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
1. Image type is going to be deprecated.
Take a look at FILESTREAM type in SQL Server 2008.
I've done saving data into varbinary(max) in ASP.NET application - I can try to take a look. If you need to test saving your data, you may try to convert to varbinary(max) some of the data, but I'm not exactly sure how to test them in plain T-SQL - give me a second to investigate.
If it's not broken, fix it until it is.
My Blog