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
 .NET Inside SQL Server (2005)
 varbinary datatype

Author  Topic 

raroskar
Starting Member

2 Posts

Posted - 2007-02-28 : 18:01:02

I want to store JPG files in my table... So far I know varbinary datatype can be used to store large object types like images,documents etc.How do I add records for this data type in table

Thanks

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-02-28 : 18:28:46
First - many people choose to store images in the file system and only store the file path and name in the database, so consider doing it that way, it has a number of advantages, see
http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html

If you do decide to put the images in the database then these articles will help
http://davidhayden.com/blog/dave/archive/2006/05/19/2948.aspx
http://davidhayden.com/blog/dave/archive/2006/07/25/SavingDisplayingPhotosInSQLServerUsingASPNET.aspx
Go to Top of Page
   

- Advertisement -