here are some notes on how to get this working.
if you are using the image datatype you can store documents of different
types in these columns and have MSSearch apply the IFIlter to the documents
stored in that column. So you could store PDF's, Word Documents, Excel
SpreadSheets, email messages from Outlook, Outlook Express Newsgroup
postings, RTF's, AutoCad drawings, etc all in the same table, and the same
column, i.e. one row's image column could contain a PDF, the next row a Word
Doc, a third row a AutoCad drawing, the fourth row a text file. In short
anything that an IFilter is written for. However you must tell MSSearch
what type of document is in the image column for that row. The way you
communicate to MSSearch what your document type for each row is, is by
pointing towards a column that contains the extension for that document.
The length of this column should be char(3)
Here is a sample table illustrating this
Outlook Express News post
Sp_FullText_column 'table_name','column_name', 0x041d, 'column_type_name'
If you do not specify an extension in the type_colname argument the text
IFilter (query.dll) will be applied. The text IFilter has an algorithm
built into it that will attempt to do word breaking on the IFilter, but will
give up if it can't discern words.
Where are instructions on how to do this, assuming that
I've downloaded the iFilter from the Adobe site?
Thanks in advance,
>There are no "dumb questions" as an old teacher once told
>No, SQL Server 7.0 (with any SP) cannot Full-Text index
documents stored in
>either a column defined with the datatype of IMAGE or
>This was a new feature added in SQL Server 2000 and is
only available in SQL
Quote:>Server 2000 using columns with datatypes of IMAGE. Yes,
the column datatype
>must be IMAGE (binary large object) in order to retain
the binary format of
>different document types, i.e., doc, pdf, etc..
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>You assume all risk for your use. ? 2001 Microsoft
>All rights reserved.
>> In SQL Server 7.0 SP3, can you full-text search
documents that are stored
>> Text fields?
>> I've been successful using an Image field on SQL Server
2000 but in SQL
>> when I go to define the full-text indexing on a table
that uses an Image
>> field I get the error:
>> Column 'DOCUMENT' of table '[dbo].[UPLOAD]' cannot be
used for full-text
>> search because it is not a character-based column.
>> I am under the impression that if I need to store
documents (word, pdf,
>> etc.) in these columns, the columns themselves need to
be of a binary