Full Text search

• Ashok Jebaraj

  Ten Centuries

  Points: 1215

  More actions

  August 5, 2008 at 11:57 pm

  #190776

  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

• SJanki

  SSCrazy

  Points: 2847

  More actions

  July 29, 2011 at 12:59 pm

  #1361045

  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')