Posted by C. on 07/21/07 20:16

On 20 Jul, 03:31, Jack <accpac...@hotmail.com> wrote:
> Hi,
> I was wondering if it is possible to search blob fields in MySQL. I
> have a MySQL DB and i am using PHP. I am storing Microsoft word files
> in it. I am wondering if it is possible to somehow search through the
> content of these words files.
>
> Thanks
>
> J


Of course its possible. You just need to read the file from the
database, open the OLE package, extract the right data stream,
linearize it, strip the formatting parse out the words, create links
in the search dictionary for words not in the exclusion list and Bob's
your uncle.

Oh....you meant is it *practical*.....no

Keep them on the filesystem and use mnogo search using wv for an input
filter.

Better yet use OpenOffice.

C.

[Back to original message]