Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
onefootswill
Starting Member
5 Posts |
 Posted - 2009-03-21 : 21:15:49
|
| Hi There,I have a question about storing images in a database. What is the best type for the attribute which will hold the image data.I know there is an image type and also a varbinary type that can do this. My driver is for whichever type conserves diskspace better. This is more important to me thatn fast retrieval.Cheers |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-03-21 : 21:33:12
|
| Which version of SQL? varbinary is preferred as image will be removed in future version of sql.Generally, images should be stored in the file system and only path should be stored in the db. |
 |
|
|
onefootswill
Starting Member
5 Posts |
Posted - 2009-03-22 : 04:20:04
|
| Thanks cshah1. And also on your tip about storing paths, as against the binary data itself. I will have a good look at that issue before I proceed.Cheers |
|
|
|
|
|
|
Images - best type