[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Full-Text indexing Blob datatype columns

Posted on 2008-11-16
11
Medium Priority
?
1,057 Views
Last Modified: 2013-12-09
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.
0
Comment
Question by:ashishanand
  • 6
  • 2
8 Comments
 
LVL 26

Expert Comment

by:Umesh
ID: 22971116
Full-text indexes can be used only with MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT column
0
 

Author Comment

by:ashishanand
ID: 22973603
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,
0
 
LVL 26

Expert Comment

by:Umesh
ID: 22973629
Pls check mnogosearch it supports all the binary files for indexing.

http://www.mnogosearch.org/
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 26

Expert Comment

by:Umesh
ID: 22992684
Did you try?
0
 

Author Comment

by:ashishanand
ID: 22993815
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.
0
 
LVL 26

Expert Comment

by:Umesh
ID: 22994493
Welcome..
0
 
LVL 26

Accepted Solution

by:
Umesh earned 2000 total points
ID: 23640903
>>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.

I think have provided the solution to the actual question - Full-text indexes can be used only with MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT column

And even provided the alternative way to do it

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

http://www.mnogosearch.org/
0
 
LVL 26

Expert Comment

by:Umesh
ID: 23641071
Thanks Angel

Thanks,
Umesh
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question