Microsoft Office 2010 Filter Packs 的相關文章

今天有同事問我怎麼透過 Microsoft Office 2010 Filter Packs 來存取(查詢) office 文件內容, 我 google 了一下, 找到相關的網頁如下:

• How to register Microsoft Filter Pack IFilters with SQL Server
  http://support.microsoft.com/kb/945934
• SQL Server Denali - FTS on properties, the cheap demo
  http://www.sqlskills.com/BLOGS/BOBB/category/Full-Text-Search.aspx
• SQL Server 2012 FileTable – Part 2
  http://www.geniiius.com/blog/sql-server-2012-filetable-part-2/
• Search Document Properties with Search Property Lists
  http://msdn.microsoft.com/en-us/library/ee677637
• Using IFilter in C#
  http://www.codeproject.com/Articles/13391/Using-IFilter-in-C
• http://www.codeproject.com/Articles/18050/C-search-engine-refactored-to-search-Word-PDF-and
  http://www.codeproject.com/Articles/18050/C-search-engine-refactored-to-search-Word-PDF-and

我手動試測試了一下相關指令:

EXEC sp_fulltext_service 'load_os_resources', 1

說明: load new IFilters


SELECT document_type, path FROM sys.fulltext_document_types

說明: 可以看到 .doc 和 .docx 都列在 doc type 裡.


附註: 舊版的 SQL Server 2000 好像也可以用 iFilter , 叫作 Microsoft Search Service.


我還沒試的指令, 及說明如下:




-- 說明: 把檔案, 放到某一個變數 @x.
DECLARE @x VARBINARY(MAX)
SET @x = (
 SELECT * FROM OPENROWSET
  (BULK 'c:\temp\SampleDoc.docx', SINGLE_BLOB) AS X)

-- 說明: 把變數(檔案) 放到 database 裡.
INSERT INTO dbo.docs VALUES('.docx',@x);

-- 說明: search 全文(所有欄位) 有 Bob 資料.
SELECT * FROM dbo.docs WHERE CONTAINS(doc, 'Bob');