Storing text documents in tables in SQL Server 2005

Tags:
Microsoft Word
Notepad
SQL Server 2005
Storage
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check the full text index properties and see if the document has been added to the index or not. It can take some time for the data to be added to the index. Documents are not added to the index at the same time that they are added to the table.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following