Re: Binary large object storage for text

In article <329C6018.680B_at_btg.com>, Kelly McCord <kmccord_at_btg.com> writes:
|> I'm interested in learning about the efficiency of BLOB storage for
|> large amounts of text vs. UNIX file system storage. When programming
|> with SQL how easy and efficient is it to manipulate and query BLOB text
|> data? Are there differences between how Sybase and Oracle handle BLOB
|> data? Can there be more than one BLOB column per table?
|>

SQL Server really doesn't let you do much more than store and retreive BLOBs, there is very little support for manipulating or querying them.

There can be more than one BLOB column per table.

-- 
---------------------------------------------------------------------
| Bret Halford                     bret_at_sybase.com               ___| 
| Sybase Technical Support         fax (303)-486-7831         __|  
| 6400 S. Fiddlers Green Circle                              |__   
| Englewood, CO 80111-4954 USA     exec sp_realitycheck()       |___
|                                                                   |
#####################################################################