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 |
|
anujrathi
Starting Member
9 Posts |
Posted - 2006-06-20 : 15:11:50
|
| Hi friends,Can any one tell me that how can we store Images ie(.bmp or .jpeg or .gif) in the SQL Server database table & also in Oracle.& after that how can I retrieve them to show in a web page.If possible then pls give the coding also |
|
|
twhelan1
Yak Posting Veteran
71 Posts |
Posted - 2006-06-20 : 16:16:29
|
| Storing images in the database is a really bad idea performance-wise. You should store the images on a file server or on the web server, and only store the path to the images in the database.~Travis |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-20 : 17:24:12
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Image,ImagesKristen |
 |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2006-06-21 : 02:12:42
|
quote: Originally posted by twhelan1 Storing images in the database is a really bad idea performance-wise. You should store the images on a file server or on the web server, and only store the path to the images in the database.~Travis
Really..?We are using Blob to store the pictures in sql. Then What is the good way to handle te pictures-- KK |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-06-21 : 07:13:42
|
| Read about BLOBs and best practices in SQL TEAMhttp://www.sqlteam.com/item.asp?ItemID=986http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37980http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=45564 |
 |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2006-06-21 : 07:43:37
|
| Thanks Africa-- KK |
 |
|
|
|
|
|