This topic is locked

Storing text file in mysql database.

8/19/2007 9:17:06 PM
PHPRunner General questions
S
simple01 author

The table I have has the following 2 fields for text file storage:
text_file_title varchar(255)

text_file_content longtext
As I have observed this is a great feature as I can search even the text file alongwith all other text fields.
It seems that in PHPRunner 4.0 I cannot store this inside the database as I find no option to store as databse file.

All what I see is that it asks to specify folder name which in my case is not needed.
On the other hand, for binary file I can store the file as longblob successfully. Here again I cannot load large files.
Help will be extremely appreciated.
Thanks a lot.

J
Jane 8/20/2007

Hi,
to upload file to the database use longblob field type.

Unfortunately you can't search in the uploaded files (in the database or on the server).