SQL Server 2012: why does full-text search not index .pdf, .cs? -
i have installed sql server 2012, executed
select document_type  sys.fulltext_document_types   the result 50 extensions, ok.
then downloaded filerpack sp2 microsoft site, installed it, executed
exec sp_fulltext_service 'load_os_resources', 1 exec sp_fulltext_service 'update_languages'    restarted sql server , executed:
select document_type  sys.fulltext_document_types   the result 151 extensions including .pdf, .cs , on.
then:
create table documentrepository (     id int not null primary key identity,     filename nvarchar(250),     filesize int,     fileextension nvarchar(10),     attachment varbinary(max) ); go  grant insert,update,select,delete on documentrepository public; go  create fulltext catalog ftscatalog default; go  create fulltext index on dbo.documentrepository (filename, attachment type column fileextension) key index pk__document__3213e83fefb4f2b9 on ftscatalog change_tracking auto; go   and added files: .pdf, .txt, .cs, .docx
- microsoft project silk.pdf 7963 .pdf
 - kdd-camera-ready-final.pdf 354 .pdf
 - pro_wcf_4_2nd_edition.pdf 22193 .pdf
 - dbw.txt 3 .txt
 - mydoc.docx 11 .docx
 - rollingfileappender.cs 50 .cs
 
and executed:
select *  documentrepository  contains(*, n'firefox')   ------ 0, (word inside pdf field)  select *  documentrepository  contains(*, n'appender')  ----- 0, (word inside .cs)  select *  documentrepository  contains(*, n'database')  -------- dbw.txt 3   .txt mydoc.docx  11  .docx   why fts not search in .pdf, .cs files?
 
 
  
Comments
Post a Comment