• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 749
  • Last Modified:

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
0
vijay11
Asked:
vijay11
  • 3
  • 2
1 Solution
 
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
 
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 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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now