Documents Formatted Text Advice.

[Andyr6381]

I need some advice of the best possible way to store text in a database. I have played about with a number of mysql databases but need some advice with the best way to get formatted text in and out.

I have an archive of 1000’s of MS word documents that I would like to put into a database. I want the documents formatting to stay the same when each page is pulled out of the database. I’m unsure of a good way to store the formatted text from the documents in the database, so that data can be searched and pull up relevant pages, preformatted.

Any help appreciated.

Andy

[OhLordy]

I'd go for a very simple table with two columns

CREATE TABLE word_docs (
unique_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
file_path VARCHAR(255) NOT NULL);

Then simply store the path of the word document. Storing binary data in the actual database can get very messy (so I've heard, never actually tried it myself). I'm almost certain the data would have to be binary or written with some sort of markuplanguage like html or XML?
HTH
Rob