[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2011-03-02
6
Medium Priority
?
741 Views
Last Modified: 2012-05-11
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
Comment
Question by:vijay11
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 27

Expert Comment

by:wilcoxon
ID: 35020441
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
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 2000 total points
ID: 35027606
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
 
LVL 27

Expert Comment

by:wilcoxon
ID: 35028354
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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 

Author Comment

by:vijay11
ID: 35029367
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
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 35029422
0
 
LVL 27

Expert Comment

by:wilcoxon
ID: 35029706
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

649 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