Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mvprice
Starting Member
3 Posts |
 Posted - 2014-06-20 : 09:02:20
|
| I have a full text catalog set up so that when files (.doc, .pdf, .xls and others) are inserted into a SQL table as image data-type they will be indexed and searchable. When the files are uploaded using OPENROWSET(BULK...SINGLE_BLOB... everything works fine. When files are uploaded (to the same table) by way of byte array, they are not indexed and are not searchable. Or at least results are not returned for these file. Am I missing something? Is there a way to make the byte array method work? |
|
|
mvprice
Starting Member
3 Posts |
Posted - 2014-06-20 : 09:13:36
|
| Correction... when inserting .txt files this way, they are indexed and are searchable. |
 |
|
|
|
|
|
Full Text Index when uploaded as byte array