<div>
Full-text indexes can be used only with MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT column
</div>


Full-text indexes can be used only with MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT column

<div>
I'm aware that in MySQL FT can be create only only for CHAR, VARCHAR or TEXTcolumns. <br />
<br />
Is there any solution for being able to FT files and be able to search them. May be using a thrid party tool like lucene. I've read about lucene but it looks like a good amount of coding would be required unlike Oracle's ctx packages that allow indexing and searching files inside blob columns.<br />
<br />
Regards,<br />

</div>


I'm aware that in MySQL FT can be create only only for CHAR, VARCHAR or TEXTcolumns.

Is there any solution for being able to FT files and be able to search them. May be using a thrid party tool like lucene. I've read about lucene but it looks like a good amount of coding would be required unlike Oracle's ctx packages that allow indexing and searching files inside blob columns.

Regards,


<div>
Pls check mnogosearch it supports all the binary files for indexing.<br />
<br />
<a href="http://www.mnogosearch.org/" rel="ugc">http://www.mnogosearch.org/</a>
</div>


Pls check mnogosearch it supports all the binary files for indexing.

http://www.mnogosearch.org/ [http://www.mnogosearch.org/]

<div>
Have not tried it yet. will need some time to do so. I've to prepare a machine for it. Will let you know once I have tried it. Thanks for your support.
</div>


Have not tried it yet. will need some time to do so. I've to prepare a machine for it. Will let you know once I have tried it. Thanks for your support.

<div>
Thanks Angel<br />
<br />
Thanks,<br />
Umesh
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Is it possible to full-text index bolb datatype columns in MySQL which store files like PDF, DOC, XLS, TXT, etc. The requirement is to be able to search the file stored in in blob column.<br />

</div>
</div>


Hi,

Is it possible to full-text index bolb datatype columns in MySQL which store files like PDF, DOC, XLS, TXT, etc. The requirement is to be able to search the file stored in in blob column.


Full-Text indexing Blob datatype columns

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.

Web Development

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.