Disable word stemming, declensions, conjugations in sql server 2005 freetext search
Posted on 2007-03-20
Lots of confusion with new SQL Server 2005 freetext search.
This is my most recent problem:
<< SELECT Txt FROM Table1 WHERE CONTAINS , ' "ANAESTHETIKUM*" ') >>
finds also Txt Columns with "ANAESTHETIKA" inside.
This is probably a word stemming problem in german language.
But isnt this kind of search ment to have a syntax like
"Select * from TableName where CONTAINS(*,'FORMSOF(INFLECTIONAL,ANAESTHETIKA)')"
Is this done because I have a default full-text language of German?
How can I disable all that stuff?
Thanks for any light...