I have a table in SQL Server 2005 which is used to store text/word documents, and I have enabled full-text search on the column and included a corresponding document type for the document.
The problem is when I upload a real NotePad Text/MS Word document saved from the NotePad/MS Word application. At first, I was able to obtain the record for the document while searching using the 'CONTAINS' clause. But when I create a '.txt' or '.doc' extension file using File I/O and store that file to the table, I am not able to find the record while searching using the 'CONTAINS' clause.
The data type for the document column is varbinary(max) and the document type column is char(5).
I have enabled auto-tracking/indexing of changes to the table.
Is there a default document type to indicate that the document being stored contains only text, and is there an indication that that the full-text search performs indexing for the document?