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-09-06 : 07:32:41
|
| pranav writes "hello!i am vb 6.0 programmer but problem is i want to store image into sql server but how can i do that?. please send me reply.my table is :create table employee( empno intempname varchar2(20)empaddress varchar2(30)empphone intempphoto [which data type use to store image]joindate datessalary double)" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-06 : 07:42:32
|
| Image DatatypeMadhivananFailing to plan is Planning to fail |
 |
|
|
Jacmac
Starting Member
11 Posts |
Posted - 2005-09-06 : 18:49:45
|
I don't know what the experts would say, but I always found that linking the files externally to be much easier than dealing with the SQL image data type. Well, that and the fact that it rubs me the wrong way to bulk up the database unnecessarily with a bunch of image data. I also like the ability to change the image file abitrarily without messing with the database. Security might be a little more complicated to deal with, but using url strings is easier to deal with on the programming side. It may not seem as clean to have all those external files, but Oracle seems to get by just fine with them.  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-07 : 02:52:35
|
| "I don't know what the experts would say"I don't know about the experts either! but I've been around for a while and I would try very hard to NOT store the image in the database, but store it on the file server and put its path and/or filename in the table instead.There's an article about both methods here:http://www.sqlteam.com/item.asp?ItemID=986Kristen |
|
|
|
|
|
|
how to store image in sql server 2000