Search
InstantDoc ID
GO

Browse By: Author | Issue

May 23, 2001 06:23 PM

Return of the BLOB

Rating: (0)
Michael Otey
SQL Server Magazine
InstantDoc ID #20460
Use the new ADO 2.6 Stream object to keep BLOBs contained
Editor's Note: This article was adapted from the SQL Server 2000 Developer's Guide (Osborne/McGraw-Hill) by Paul Conte and Michael Otey.

When you're designing and programming databases, images and audio or video clips probably aren't among the first things that you consider storing. However, today's databases often need to store employee photos, product pictures, and the like. Even the ability to play...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Very insightful! I wasn't so familiar with how to deal with BLOBs prior to reading the article.

Paul12/6/2006 3:01:04 PM

This article said that we can store any type of file into sql serve image data type. but after i try it, yes, it can store exe, zip and png image file, but when i extract it (exe, zip or png file), after the file was created, it cannot open..it return error. how to solve this problem?

yusli 3/29/2004 1:46:46 AM

This article is very interesting. I've been searching for this kind of explaination. I hope to download the whole code (not just the listing) including the files mentioned in the article. Thanks.

Roel Ang 6/2/2001 11:29:26 AM

What about performance? It's probably always slower than the file system, but how much? And how much do reads and writes of BLOBs affect the total system performance?

Mattias Thorslund 5/25/2001 7:15:45 AM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.