Treatment of extension column changed in SP4?
- From: glenlow@xxxxxxxxxxxxx
- Date: 11 Oct 2005 20:29:51 -0700
Hi All
I have several SQL Server 2000 databases that have tables which are
full-text indexed. In particular I index an image column and specify a
document type column. This type column often has a compound extension
like '.doc.gz' and I've written and enabled an IFilter on the box to
take files ending in .doc.gz etc., decompress it to the original
extension .doc and call the registered IFilter on .doc.
Up to SP3, everything seems to be hunky-dory and the SQL Server
dutifully passes the temp file over to my IFilter for indexing. The
temp files it sees are of the form "abcd..doc.gz"
After SP4 (or some other change I can't determine, although this
problem has cropped up on a brand new machine with only SQL 2000 SP4 +
Win2003 Server on it), the temp files are now of the form "abcd.gz" and
thus my IFilter can no longer figure out the original extension.
Is this a known issue with SP4? Do I need to use "doc.gz" instead of
".doc.gz" in the type column? Am I going insane?
Cheers,
Glen Low, Pixelglow Software
www.pixelglow.com
.
- Follow-Ups:
- Re: Treatment of extension column changed in SP4?
- From: Hilary Cotter
- Re: Treatment of extension column changed in SP4?
- From: John Kane
- Re: Treatment of extension column changed in SP4?
- Prev by Date: Re: updating a FT index - not what I expected
- Next by Date: Re: Get Info from Full Text Search Catalog
- Previous by thread: & in FTS
- Next by thread: Re: Treatment of extension column changed in SP4?
- Index(es):
Relevant Pages
|
