JeevesBond — Wed, 31 Aug 2005 12:23:45 +0000

No problem!

Good luck, and yes feel free to come back if you need anymore help.

subu — Tue, 30 Aug 2005 21:17:00 +0000

thanks jeeves for that info. will get back if i have more questions

JeevesBond — Wed, 24 Aug 2005 21:43:23 +0000

Quote: If i choose this option, what needs to done to convert the file back to text without losing format and any data when accessed?

Something like PHP would do it, upload the file, open the file, squirt file contents into DB and close.
When you want to open the file again, open DB record, squirt data into file, close, point client browser at file.

Storing this as a BLOB or LONGBLOB wouldn't affect the formatting of the file, that's the intention of the datatype I guess.

That's how I think it's done as I've never had to do exactly what you're asking before.

Quote:
2. To save the text file in a directory on the server and make the database point to the file. What needs to be done/ what datatype needs to be used for this option?

Now for the second idea of yours - which will be faster and more efficient btw.

Upload file, store in a directory. Use a CHAR or VARCHAR data type to store the path and filename of the document on the server, again you'd use PHP for this php.net has some very good documentation online that you can use for the purpose.

And here's a good place to start:
http://uk2.php.net/manual/en/features.file-upload.php

Have fun and come back if you need any further help!

bja888 — Wed, 24 Aug 2005 16:18:45 +0000

Database is to large file as filing cabinet is to elephant.
It works... but doesn’t server its purpose. Suggestion... pay someone who knows what their doing. It saves so much time and the world goes round.