Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Full Text search Expand / Collapse
Author
Message
Posted Tuesday, August 05, 2008 11:57 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Friday, July 29, 2011 12:59 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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 »

Add to briefcase

Permissions Expand / Collapse