How to search a string value in image column in sybase and sql server

I have a column in a table with image datatype which  stores the pdf , excel and word files (office of any version) . How can I search for a particular  string in the the image column
vijay11Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Aaron ShiloConnect With a Mentor Chief Database ArchitectCommented:
yes you can
you need to install the adobe ifilter

read this : http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/
0
 
wilcoxonCommented:
I don't think you can.  I believe you have to get the image data for every row and look at the image data independently using some other software.
0
 
wilcoxonCommented:
I guess I should have been explicit.  I was talking about Sybase (as I know nothing SQL Server specific).

iFilter will only work with SQL Server and technically doesn't allow searching image data - it scans through the database and builds up an index that you search (at least that's my understanding from scanning through the link).
0
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
vijay11Author Commented:
Sorry for the confusion , the data that is stored in the column (image) is string value only . What we are doing is from the Front end We importing a file (pdf,word or excel ) to that column which has the data type image, but the content in pdf,word or excel is string only .Basically we have to search for a string in a column whise data type is image
0
 
Aaron ShiloChief Database ArchitectCommented:
0
 
wilcoxonCommented:
vijay1, which database are you using?  If you are using Sybase, I don't think it is possible.  If you are using SQL Server (version 7 or later), then it looks like ifilter will work (as suggested by ashilo).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.