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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Storing Image

Author  Topic 

Srain
Starting Member

23 Posts

Posted - 2009-11-26 : 01:11:19
Hi All,

Please can anyone let me know if we can store a image/photo in a ntext field.

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2009-11-26 : 01:14:49
You can convert as bytes and store it in image Column!

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/
Go to Top of Page

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-11-26 : 04:29:15
Refer this..
http://msdn.microsoft.com/en-us/library/aa175795(SQL.80).aspx


-------------------------
R...
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-11-26 : 18:03:32
dont store your image in the db.

store them in a folder, and the path in the db and present them in the presentation layer, there are tons of examples online
Go to Top of Page

Srain
Starting Member

23 Posts

Posted - 2009-12-02 : 13:03:35

Requirement is - In a text area along with text the image files(screen print) should be copied and need to be stored in Database.

Please let me know in above case how can we store the image in DB. what would be the data type.
From asp page what datatype should store both image along with text.



quote:
Originally posted by afrika

dont store your image in the db.

store them in a folder, and the path in the db and present them in the presentation layer, there are tons of examples online

Go to Top of Page
   

- Advertisement -