all groups > sql server (alternate) > may 2005 >
You're in the

sql server (alternate)

group:

Storing pdfs in an image field


Storing pdfs in an image field Arlyn
5/13/2005 9:51:27 AM
sql server (alternate):
I am using an image datatype to store multiple filetypes includeing plain
text data. it works except for pdf Data. When I retrieve the the file
couldn't be opened in acrobat reader and the file was 3KB bigger than the
original.
Any suggestions would be helpful.

Re: Storing pdfs in an image field John Bell
5/14/2005 12:00:00 AM
Hi

You don't say how you are importing/exporting these, but you may want to
look at the textcopy sample.
If you don't need to hold them in the database it would be easier to just
store the file location information.

John
[quoted text, click to view]

Re: Storing pdfs in an image field Erland Sommarskog
5/14/2005 12:00:00 AM
John Bell (jbellnewsposts@hotmail.com) writes:
[quoted text, click to view]

I don't think so. This sample uses DB-Library, which should not be used
for new applications.

[quoted text, click to view]

If it works for other types of files, it may be something pecuilar with
PDFs, which I don't have any knowledge of.

It would help if you told us you store the files. Sample code would be
a good thing.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
Re: Storing pdfs in an image field John Bell
5/14/2005 12:00:00 AM
To clarify!

If using Textcopy imports/exports files correctly then it implies something
wrong in your code, not that you should change your code to use the textcopy
source.

John

[quoted text, click to view]

AddThis Social Bookmark Button