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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Save Picture as BIT

Author  Topic 

shanmugaraj
Posting Yak Master

219 Posts

Posted - 2006-04-06 : 08:31:25
I want to save a picture uploaded by the user in BIT in Sql Database ... Help me

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-06 : 08:42:48
Store the physical path of the file in the table and save files in the server
Otherwise refer this
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2006-04-06 : 18:02:05
Are you sure you want to use bit? I guess it's OK for single-pixel black and white images...
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2006-04-06 : 20:16:45
quote:
Originally posted by robvolk

Are you sure you want to use bit?

Compression algorithms have advanced a lot in the past few years.
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-04-06 : 21:09:12
Also refer to these

http://sqlteam.com/forums/topic.asp?TOPIC_ID=45564
http://sqlteam.com/forums/topic.asp?TOPIC_ID=37980
http://sqlteam.com/item.asp?ItemID=986
Go to Top of Page

shanmugaraj
Posting Yak Master

219 Posts

Posted - 2006-04-07 : 00:48:20
Thank you afrikam,
I am reading the links sent by u... Seems usefull..
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-04-07 : 02:32:59
glad it helped. Or better yet you could always make reference to the parent link i got them from

FAQ: frequently given answers
http://sqlteam.com/forums/topic.asp?TOPIC_ID=55210

Go to Top of Page
   

- Advertisement -