Hi

Desperation has lead me to post. Usually I am able to fix problems by just reading through the newsgroups.

I am working on a full text search for an image column. I have an image column (docData) defined - as image (16) and a docExt column defined as char(4). Here are the results of sp_help_fulltext_columns

dbo 1106102981 tbl_Document docNameFormal 5 NULL NULL 103
dbo 1106102981 tbl_Document docData 7 docExt 6 103

The catalog populates (count 6 - small test table) and application log displays no errors. The FTI will return a search on docNameFormal but not on the image column. I loaded the images in the image column using ADO and Textcopy (as outlined in a previous post by John)

I am using SQL 2000 with SP3a on Windows 2000 professional

Thank you

Suz,
Is your docExt column that is defined as char(4) nullable?
When you store the normal 3 character file extensions (doc, xls, etc.) do
you also store the "." (dot) as well in the char(4) column?
If you alter this column to be a varchar(3) or varchar(4) and then use "doc"
or ".doc" respectively, and then run a Full Population, do the files get FT
Indexed properly (check the Application event log for "Microsoft Search"
errors) and can you successfully return results from a CONTAINS query using
know words in these files?

Thanks,
John



[quoted text, click to view]
column (docData) defined - as image (16) and a docExt column defined as
char(4). Here are the results of sp_help_fulltext_columns:
[quoted text, click to view]
displays no errors. The FTI will return a search on docNameFormal but not on
the image column. I loaded the images in the image column using ADO and
Textcopy (as outlined in a previous post by John).
[quoted text, click to view]

John,

Thanks so much for your quick reply. The char field was not nullable. I changed the field to varchar and nullable and the Contains query worked!

Thanks again