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

FTS Multiple tables and columns. Different spin. Help!

Been reading thru all the posts and KB's on dealing with searching
across multiple columns. Most examples indicate you know what you're
looking for in each column.
Here's my big problem:
A: I have 12 tables, each with multiple columns that need to be
searched.
B: User will enter a search condition in any or all the boxes below
1 - "All these words"
2 - "Exact phrase"
3 - "Any of these words"
Unlike the SP3 "fix", if they enter "house cat" in "all these words", I
want a match if "house" and "cat" are in different tables.
In a nutshell, I need to take the 3 inputs, and search across all the
tables, and get ranked results.
The only answer I see, which seems to be kludge, is to create another
table with one column that concats all the indexable columns for all
the tables.
Doing a monster union with multiple contains/free/? on each select
seems really ugly and would kill performance.
Am I missing the boat, or does anyone have a better solution?
All comments are REALLY appreciated, as I just pulled out the last hair
on my head!
Thanks.
My approach would be to consolidate all of your data into a single table. I
realize it doesn't help much.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"woody" <shellymatthys@.yahoo.com> wrote in message
news:1116568453.936941.176620@.g47g2000cwa.googlegr oups.com...
> Been reading thru all the posts and KB's on dealing with searching
> across multiple columns. Most examples indicate you know what you're
> looking for in each column.
> Here's my big problem:
> A: I have 12 tables, each with multiple columns that need to be
> searched.
> B: User will enter a search condition in any or all the boxes below
> 1 - "All these words"
> 2 - "Exact phrase"
> 3 - "Any of these words"
> Unlike the SP3 "fix", if they enter "house cat" in "all these words", I
> want a match if "house" and "cat" are in different tables.
> In a nutshell, I need to take the 3 inputs, and search across all the
> tables, and get ranked results.
> The only answer I see, which seems to be kludge, is to create another
> table with one column that concats all the indexable columns for all
> the tables.
> Doing a monster union with multiple contains/free/? on each select
> seems really ugly and would kill performance.
> Am I missing the boat, or does anyone have a better solution?
> All comments are REALLY appreciated, as I just pulled out the last hair
> on my head!
> Thanks.
>