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?
 
Aaron ShiloChief 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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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.