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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-07 : 08:59:31
|
| chandu reddy writes " Hello Team can u plzz tell me how to store an email attachment to a sql server database as a image. for example ifa candidate want to send his resume as attachment and i want to store the attachment as a image in the sql server database. how cani do it.plzzz tell me. thank u" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-01-07 : 09:04:50
|
well u have an image datatype you can use.but everyone here will tell you not to store images in a database.store images in the folder on the disk and put a relative path to the image in db.Go with the flow & have fun! Else fight the flow  |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-01-08 : 06:49:42
|
| I think I might well store an EMail attachment as an IMAGE datatype, if I was building an Email archiving system. Low retrieval, need for integrity between table data and file-attachments, important to have synchronised backup, and so on.However, for a Web Image the benefit of caching, the need for high-occurence of retrival, the benefit of filesystem retrieval speed, etc. would most definitely swing me the other way.There again maybe it isn't an archival system!Kristen |
|
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-11 : 08:23:15
|
| Good link Frank, thanks. |
|
|
|
|
|
|
storing email attachments in the sql server database as image