At 16:00 +0530 1/14/03, Vikash K Agarwal wrote:
Hi
We want to create a knowledge base using PHP-MYSQL and if required other
tools like specialized search engine. The knowledge base may consists
for normal text content, HTML content, PDF files, DOC files etc. The
preferred OS is RH Linux 7.3.
My queries are:
1. Should we store these files as blobs in MYSQL or in the file system
and then store only the name in the database. Please consider the
archival issue in both
2. In either of the cases above how can I search thru non-text
documents. Is there ne specialized search engine for that over and above
full-text of MYSQL
Just a small point: If you want to use full-text searching, you'll need
to use a TEXT type rather than a BLOB type. You cannot create a FULLTEXT
index on BLOB columns.
3. I have found a limit of 16MB for blob storage in mysql 3.2x. Is that
correct and therefore shud we start development assuming a time for 4.x
to be available in stable-production form.
Also I m new to mailing lists so let me know if I m not in conformance
of ne rules, wud gladly correct myself.
Thx
Vikash K Agarwal
sql, query
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
