php and the mighty pdf

[vanila2000]

I have php5.2.6 version installed in Linux. I have several php files stored in a directory which I would like to insert into my Oracle Database. Simple fopen gives me a number of junk characters and the pdf file is not opened. Can anyone please give me directions or code to open a pdf file from the OS and insert into Oracle DB?

I would be very very thankful,caz been struggling with this one for some time now.

Priya

[etully]

You can create a field type of "blob" and put binary data (like a PDF) in there but it's rarely necessary. And by "rarely", I mean I can't really think of a reason why you'd want to.

What I do (and everyone I know does) is one of these solutions:

1. just make a text field and store the filename in the database
2. create a record in the database, get the record's ID number, and rename the PDF to $id.pdf

I can't really think of a good reason to put the data in the database when you can just make a pointer to a file.

[vanila2000]

thankyou. But I am already following that method only. But my application needs free text search in the files, so, I need them in the database to use oracle text search.