How to save a PDF file in a SQL Server column using Delphi code

Question

G'd day, everyone...

Here is the scenario. My user wants to save a PDF file into the database (yeah, I know, that's not the optimal way to do it, but ... he pays, so I keep my mouth shut ;) ), so I decided to create a Binary column in a table in SQL Server 2008 R2 database.

And now, the problem. I'm developing in Delphi 6, and I have the slightest idea how to accomplish this..., can you provide me kinda help here, please?

Thanks in advance for your kindness.

Not being a Delphi guy myself, I'll tread lightly here. But, I would recommend varbinary(max) for the data type, instead of binary. Binary is limited to 8k, but varbinary(max) allows up to 2GB (source: msdn.microsoft.com/en-us/library/ms188362.aspx) — John Dewey
– John Dewey, Commented Mar 15, 2012 at 16:57
There are a lot of well known products that store files inside the DB. SharePoint is one of them (although there is a SharePoint external storage API also). BTW, "but ... he pays, so I keep my mouth shut" - this kind of approach can backfire at you later. — kobik
– kobik, Commented Mar 15, 2012 at 23:14

Chris Thornton · Accepted Answer · 2012-03-15 17:41:06Z

4

You can stream the PDF into a blob field. I use this technique for saving .JPG and .PNG images into a DBISAM database. You can probably find examples of doing this for images (stream an image into a blob field).

answered Mar 15, 2012 at 17:41

Chris Thornton

15.9k5 gold badges39 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to save a PDF file in a SQL Server column using Delphi code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related