FTS giving me no results
- From: g.lebek@xxxxxxxx
- Date: Thu, 30 Aug 2007 02:19:09 -0700
hi
FTS gives me no results all the time.
from the beginnning i have created table with columns: ImageColumn
(Image), document_type(varchar(4)) and filepath(varchar(200))
i have created FullTextIndex on column ImageColumn and type -
document_type.
no i have an application which convert documents to binary and i
insert them to ImageColumn column. As i open the table i see <binary
data> on ImageCol column. It is correctly presented cause i have read
data from that column and usedBinaryWriter and as a result i had the
same document file.
in document_type column i have extensions = doc or htm
i use queri in SQL console
Select * from cm_search_documents WHERE FREETEXT(ImageCol, 'a')
and it gives me no results every time...
I have SQL Server 2005 and enabled FTS cause it works on strings...
anyone?
thanks in advance
.
- Follow-Ups:
- Re: FTS giving me no results
- From: Jean-Pierre Riehl
- Re: FTS giving me no results
- Prev by Date: Re: Dtsearch
- Next by Date: Re: FTS giving me no results
- Previous by thread: Dtsearch
- Next by thread: Re: FTS giving me no results
- Index(es):
Loading