Manage Image data types

I must save in a column of a table whole documents (for example .doc files).
I made a full text index in that table. I asociated another column (string type)
to the image column. That column store the extension of the document
stored.
Now I want to interogate the column using the specific words as contains or
treetext. The problem is that any query I made get no results although I am sure
there are results.
Is anybody know what I must do?
If you know more about these image datatypes I would be very glad to know because
the help offer minimal informations concerning this image matter.
Thanks'

The image (binary) field is a binary datatype. It does not store the actual text contained in the document. Storing binary objects is not recommended in most cases, as it is usually easier and more effecient to store files in the filesystem.

To be able to search Word documents, use the built-in document indexer that comes with IIS.

hi,
First of all i have never used image datatype ... not exactly sure if its only used for binary data....

But for your case i suggest you use datatype as text ...
You have created a fulltext table..........
May be you have missed out on populating those ( assuming you have created catalog, enabled tatabase for full text indexing....)

There is also another way of full text indexing of files (doc , txt etc)....directly from the hard disk... no need to insert these inside sql server ... give it a try

regards
Robinson