Freetexttable Not Finding Inflectional Forms

We're using SQL Server 2005 service pack 1. It was my understanding that
FreeTextTable automatically includes inflectional forms. We're not able to
get any inflectional forms of words during the search (even if we use
Contains with the special syntax). Are we missing something in the server
configuration? Or is there a bug somewhere?
Thanks,
Krip
Are you wrapping your freetext search in double quotes - this disables the
stemming (inflectional search)?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Krip" <amk@.kynetix.com> wrote in message
news:9E599183-45E3-4CA8-8628-540038B91EB6@.microsoft.com...
> We're using SQL Server 2005 service pack 1. It was my understanding that
> FreeTextTable automatically includes inflectional forms. We're not able
> to get any inflectional forms of words during the search (even if we use
> Contains with the special syntax). Are we missing something in the server
> configuration? Or is there a bug somewhere?
> Thanks,
> Krip
>
|||Hilary,
Nope, not wrapping with double quotes. Here's the clause:
INNER JOIN FreeTextTable(myTable, myField, 'tests') as FTT
I have 'test' in the data but 'tests' doesn't find it. That's just one
example (fox works but not foxes; landed works but not landing).
The following doesn't work either:
SELECT *
FROM myTable
WHERE CONTAINS(*, 'FORMSOF (INFLECTIONAL, foxes)')
Also, I've now installed SP2 and rebuilt the catalag - same issue.
Is there some place to enable inflectional forms? Or is there a dictionary
to populate?
Thanks,
Krip
|||Perhaps it is a language issue, what does this return? sp_configure 'default
full-text language'
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Krip" <amk@.kynetix.com> wrote in message
news:3424FB65-92CF-40BA-B08E-436298FABB96@.microsoft.com...
> Hilary,
> Nope, not wrapping with double quotes. Here's the clause:
> INNER JOIN FreeTextTable(myTable, myField, 'tests') as FTT
> I have 'test' in the data but 'tests' doesn't find it. That's just one
> example (fox works but not foxes; landed works but not landing).
> The following doesn't work either:
> SELECT *
> FROM myTable
> WHERE CONTAINS(*, 'FORMSOF (INFLECTIONAL, foxes)')
> Also, I've now installed SP2 and rebuilt the catalag - same issue.
> Is there some place to enable inflectional forms? Or is there a
> dictionary to populate?
> Thanks,
> Krip
>
>
|||Hilary,
It returns the following:
name: default full-text language
minimum: 0
maximum: 2147483647
config_value: 1033
run_value: 1033
Thanks for your help,
Krip