Re: An issue with Full Text Search against PDF blobs...
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Mon, 13 Aug 2007 23:00:07 -0400
Check the gatherer logs to see what the status of your population was.
--
relevantNoise - dedicated to mining blogs for business intelligence.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Camilo" <Camilo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:92BEFB18-89BF-4C7E-8B11-769B0C329B7B@xxxxxxxxxxxxxxxx
My client is trying to use SQL Server Full Text Search to search PDFs
stored
in a varbinary(max) column. Full text search works fine for other
Microsoft
Office documents stored in the same table but it does NOT give back any
results from the PDF documents.
Following is a high-level view of what the client did:
1. Installed Adobe PDF IFilter 6.0
2. Ran the stored procedure sp_fulltext_service (as documented)
3. Restarted the server
4. Verified that the filter got properly installed by querying the system
view
sys.fulltext_document_types
5. Created a full text index on the table with the documents
6. Started a full population of the index
7. Ran a sample query with a string he knows is in the PDF file like the
following:
select * from documents where freetext(document, 'Review') and got no
results
back
8. Ran the same sample query with a string he knows is in some Word files
like the
following: select * from documents where freetext(document, 'SQL') the
query
returned several rows back as expected.
Does anybody know what might be happening here?
Thank you!
Camilo Leon
.
- Prev by Date: Re: SQL 2005 Cluster with dedicated nic for Sharepoint DB
- Next by Date: Re: newbie: Full Text Search Against PDF Blobs
- Previous by thread: Re: An issue with Full Text Search against PDF blobs...
- Next by thread: SQL 2005 Cluster with dedicated nic for Sharepoint DB
- Index(es):
Relevant Pages
|
