Is there a way to avoid wordbreaking functionality when performing a
fulltext query in a german SQL Server 2000 on a Win Server 2003?
Example: when using ... CONTAINSTABLE([column], "'posthorn'") ..., my
resultset contains records containing "postfrisch" and "posthorn"
because (I think) of the wordbreaking to "post" and "horn" which are
two different nouns in German (alike "post" and "frisch").
But my desired result should only contain records with "posthorn" and
nothing else. When reading the groups, I found something like activate
the english wordbreaker DLL, but I cannot find out how to do this!? Or
is there a better way to achive this?
Thanks for help!
Hilary Cotter - 30 Dec 2005 11:53 GMT
Try using the neutral word breaker. Have a look at this tutorial to see how
to select different language word breakers.
http://www.indexserverfaq.com/SQLFTIWizard.htm

Signature
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
> Is there a way to avoid wordbreaking functionality when performing a
> fulltext query in a german SQL Server 2000 on a Win Server 2003?
[quoted text clipped - 10 lines]
>
> Thanks for help!
Dirk - 30 Dec 2005 16:53 GMT
Thank you, Hilary, for this helpful information!