Data type to store photo

hello,

I want to store the photo in the sql server 2005 , what datatype should I use?

Moving to SQL Forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=158&SiteID=1

Answer: VarBinary(MAX)

|||

Hi Amit,

You can use the datatype to store the images or data in DATABASE but it is not advisable, best practise says that it is better to store only path of the images or documents and let it play with front end application here is a Research paper availble prepared by ussell Sears; Catharine Van Ingen; Jim Gray http://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2006-45

HTH

Hemantgiri S. Goswami

|||but wht about replacement or file movement /deletion of the file ...the system /application will crash immediately....
|||

Hi Amit,

The deletion/file movement can be handle through front end application.