Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / December 2005

Tip: Looking for answers? Try searching our database.

sql server fulltext query results

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dirk - 30 Dec 2005 08:55 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.