FTS not return image column results

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:
dbo1106102981tbl_DocumentdocNameFormal5NULLNULL1033
dbo1106102981tbl_DocumentdocData7docExt61033
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
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
"Suz" <nightfrost@.hotmail.com> wrote in message
news:3310C0C4-5853-4DBB-8505-1C90279838CC@.microsoft.com...
> 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 1033
> dbo 1106102981 tbl_Document docData 7 docExt 6 1033
> 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
|||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!
Suz