Problems using DTS to build a table just for FT indexing - 05-26-2005 , 02:17 PM
Description: We are using a DTS to build a table just for FT indexing.
Basically we gather all of the words from the fields we'd like to search,
and put them into a single table (moosejaw_tblFullText). Then we're using
FormsOf (Inflecitonal...) to get results as the SQL below shows.
For one of our customers, we need to be able to differentiate between words
like "person", "2-person", and "4-person". Right now the SQL below returns
ALL results for "person". From what I've read, I believe it is considering
the dash "-" to be a word, and since "2" is a noise word, it effectively
only searches for "person". I read that this was fixed in Windows Server
2003, in the langwrbk.dll, but it does not appear so.
Does anyone have any suggestions or ideas?
Select uvw.pf_id, ft.* From uvw_cat_prod_backorder uvw, moosejaw_tblFullText
ft Where uvw.pf_id=ft.pf_id AND Contains(ft.Description,' FORMSOF
(INFLECTIONAL, "2-person") ')
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
RE: Problems using DTS to build a table just for FT indexing - 05-26-2005 , 10:22 PM
This behavior is as designed. Please refer to the following article:
200043 PRB: Dashes '-' Ignored in Search with SQL Full-Text and MSIDXS
A custom word breaker that does not break on hyphens is the only solution
purely Indexing Service standpoint. The following links are for your
Word Breaker and Stemmer Sample
Constructing Language Resource Components
Implementing a Word Breaker
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.