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

SQL Server Full text search Expand / Collapse
Author
Message
Posted Sunday, August 10, 2008 10: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 #550000
Posted Monday, August 11, 2008 7:07 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 4:00 AM
Points: 4,427, Visits: 4,175
To answer you're questions
1) Yes, you can also search on BLOB data and documents like .doc or .pdf files stored in your database.

2) Implementing it is pretty easy, though you have to become familiar with some new concepts and syntax. See here for more info.


Markus Bohse
Post #550215
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse