Full Text search

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Strategies » Full Text search

Full Text search

Rate Topic

Display Mode

Topic Options

Author

Message

Ashok Jebaraj

Posted Tuesday, August 05, 2008 11:57 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, November 15, 2012 1:31 PM
Points: 33, Visits: 139

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

Post #547274

SJanki

Posted Friday, July 29, 2011 12:59 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 3:44 PM
Points: 70, Visits: 194

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

Post #1151221

« Prev Topic | Next Topic »

Permissions