I am using SQL 2000, and as per the docs, I should be able to create
Full-text indexes on MS Word docs stored in image columns.
Just to test this, I created a new table, and used the TEXTCOPY application
to add around 20 rows in it, one word document per row.
The table schema is as follows :
cnd_id int
ENTRY_DATE datetime
UPDATE_DATE datetime
USER_RESUME text
WORD_RESUME image
BINDCOL char
I used the full-text indexing wizard to specify the image column
WORD_RESUME, and the associated binding column BINDCOL, which contains the
value '.doc' for each row. The wizard then notifies me that the index has
been created, but not populated. On completing full population, the
properties of the catalog read as follows :
Item Count : 21
Catalog Size : 1 MB
Unique Key Count : 8
I'm quite positive that there are more than 8 non-noise words in the 21
docs in this table. On adding more rows, and populating the catalog again,
the key count stays the same. And both the CONTAINS and FREETEXT predicates
give me no result when used to query this column.
I already use full-text indexes on text columns, without any problem. So my
best guess is that the SQL 2000 filters for .doc are either missing or not
working.
Can anyone help me on this one ?
Vishal.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
