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.

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" <Arlyn@ideapoint.ca> wrote in message
news:1189j851kjjnm5e@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.
>

John Bell (jbellnewsposts@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" <Arlyn@ideapoint.ca> wrote in message
> news:1189j851kjjnm5e@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, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

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" <jbellnewsposts@hotmail.com> wrote in message
news:4285a679$0$2590$da0feed9@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" <Arlyn@ideapoint.ca> wrote in message
> news:1189j851kjjnm5e@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.
>>
>
>