duke63
asked on
Disable word stemming, declensions, conjugations in sql server 2005 freetext search
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(INFLEC TIONAL,ANA ESTHETIKA) ')"
Is this done because I have a default full-text language of German?
How can I disable all that stuff?
Thanks for any light...
duke63
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(INFLEC
Is this done because I have a default full-text language of German?
How can I disable all that stuff?
Thanks for any light...
duke63
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
(sorry for the late response)
I've allready read these pages but could not find a reason for this behavior?