varbinary datatype - SQL Server Forums

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources