April 8, 2003 at 4:09 pm
I have PDF files need to be stroed in the DB. What datatype it will be, BOLB, IMAGE, OR BINARY? How do I load PDF files to the DB?
Does SQL server have function like DBMS_LOB package in Oracle?
April 8, 2003 at 5:49 pm
Image generally used. MS has a utility called BII, part of the resource kit, that you can use for bulk load. Most data access with blobs(image)is done via ADO and the stream object.
Andy
April 9, 2003 at 3:13 am
Hi,
there are many pros and cons about storing binary data in a db vs. using the filesystem and I have seen on other forums quite philosophical discussions about this. I do also store pdf, xls, doc in a db, but I keep them in a separate db that is used for nothing else and once the data is stored it does not change at all. For me this solution works great, but there might situations where this is not so appropriate. I think this is kinda classical "it depends on your situation and needs" topics
If you decide to store you'll need the image datatype and, as Andy said, with ADO and the Stream object handling is quite easy
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply