August 5, 2008 at 11:57 pm
Hi,
I am new to full text search. I have some questions.
1. Does SQL Server full-Text search, search only on text data or can it search on Binary data?
2. There are many ways to stores files in SQL Server. Can Full-text search, search the content of the document? If yes...how do we implement this.
Ashok Jebaraj
July 29, 2011 at 12:59 pm
Hi, Not sure if you got this answer.
But yes, full test search can search in binary data also (VarBinary(MAX))
To implement Full Text Search -->
Add a column 'Type' in the table where you store the binary data.The Type column should have the value of the document type eg. '.doc' , '.pdf' etc.
Create a Full Text Index on the table-->Right Click the table,select Full Text Index-->Define Full Text Index.
Follow the steps, its explainatory.
You will need a non-null unique key in the table.
You also need a catalog-->Database-->Storage-->Full Text Catalog-->Create new catalog
Once the Full Text Index is created, you can search the phrase as-->
Select * from TableName Where Contains(ColumnToBeSearched, 'testtosearch')
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply