User Guide for PaperSave for Blackbaud's Student Information System > Appendix

Overview of Full Text Search:

Full Text Search feature facilitates you to search documents based on their contents stored in PaperSave Database for different MIME types like .pdf, .tif or .tiff, .html and all the MS-Office type documents for .doc, .docx, .xls, .xlsx, .ppt, .pptx and .msg.

Full Text Search feature is installed while SQL Server is installed, if the required option is selected during installation. If Full Text Search is not installed then while installing PaperSave ISO or PaperSave Rollup, you will be prompted for a warning message. However, you will be able to complete further PaperSave Installation successfully without any interruption. Click here to know more on Full Text Search installation.

Full-text search allows fast and flexible indexing for keyword-based query for char, varchar, nchar, nvarchar, text, ntext, image, xml, or varbinary(max) and FILESTREAM data stored in SQL Server database. Unlike the LIKE predicate, which only works on character patterns, full-text queries perform a linguistic search against this data, operating on words and phrases based on rules of a particular language. For more information go through http://msdn.microsoft.com/en-us/library/ms345119.aspx