By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,386 Members | 1,850 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,386 IT Pros & Developers. It's quick & easy.

Storing pdfs in an image field

P: n/a
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.
Jul 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
"Arlyn" <Ar***@ideapoint.ca> wrote in message
news:11*************@corp.supernews.com...
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.

Jul 23 '05 #2

P: n/a
John Bell (jb************@hotmail.com) writes:
You don't say how you are importing/exporting these, but you may want to
look at the textcopy sample.
I don't think so. This sample uses DB-Library, which should not be used
for new applications.
"Arlyn" <Ar***@ideapoint.ca> wrote in message
news:11*************@corp.supernews.com...
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.


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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #3

P: n/a
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

"John Bell" <jb************@hotmail.com> wrote in message
news:42**********************@news.zen.co.uk...
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
"Arlyn" <Ar***@ideapoint.ca> wrote in message
news:11*************@corp.supernews.com...
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.


Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.