sql server full text search: No results for ntext and image searches -- sql server full text search

No results for ntext and image searches

hamiryar NO[at]SPAM hotmail.com
12/3/2003 9:15:14 AM

sql server full text search: SQL Server 2000 on Windows 2000 and XP Pro

I've created a full text index successfully. And I've confirmed in the
application event log that MSSearch ran successfully. I get search
results on all fields except the ntext and the image field. I don't
get an error. I just get 0 results.

These query varchar fields and work:
------------------------------------
select [key],[rank]
from freetexttable(tbldocument,department,'Physics')

select namespace
from tbldocument
where freetext(department,'Physics')

These queries do not work querying ntext and image columns
----------------------------------------------------------
select namespace
from tbldocument
where freetext(contenttext,'Hi there')

select namespace
from tbldocument
where freetext(content,'Hi there')

select namespace
from pbsdocument
where contains(contenttext,'Hi')

-Any help would be greatly appreciated.

Re: No results for ntext and image searches

John Kane
12/3/2003 10:26:22 AM

Hassib,
Could you post the output of sp_help tbldocument
as this would help us understand your problem. What is the datatype for the
"file extension" column that you bind to the IMAGE column? Also, what type
of text (html ?) and language is in the NText column as well as what is the
language of the documents (MS Word) in the IMAGE column? Finally, how did
you upload/insert the MS Word documents into the IMAGE column? Please review
the Application event log for any "Microsoft Search" source events, warning
or errors.

Regards,
John

[quoted text, click to view]