Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Understanding full text indexing
Message
From
16/12/2010 21:36:37
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Full text indexing
Title:
Understanding full text indexing
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01493016
Message ID:
01493016
Views:
131
I am trying to understand a behavior of SQL Server in regards to the full text indexing.

If I have the following SQL:
DECLARE @Parameter1 Varchar(60)
DECLARE @Parameter2 Varchar(60)
DECLARE @AddDate DateTime
DECLARE @AddDate2 DateTime
DECLARE @NoClient Integer

SET @Parameter1='"THE REPORT WRITER"'
SET @Parameter2='"THE REPORT WRITER"'
SET @AddDate='2008-12-16 00:00:00'
SET @AddDate2='2010-12-16 23:59:59'
SET @NoClient=5

SELECT Thread.Numero
 FROM Thread (NOLOCK)
  WHERE (Contains (Thread.Notes, @Parameter1) OR Contains (Thread.Title, @Parameter2)) 
  AND Thread.AddDate>=@AddDate AND Thread.AddDate<=@AddDate2 AND Thread.NoClient=@NoClient
   ORDER BY Thread.Numero DESC
This returns messages where "REPORT WRITER" is found and seems to ignore the "THE" in front as if this is a common word.

However, if I search for "PROBLEM EVEN WITH", this will find messages with "PROBLEM EVEN WHEN" as if there is a certain percentage of phonetic ressemblance.

Basically, I do not need anything of that. In both occasions, the exact string should be found exactly in the messages. Thus, if a message is being returned, this would be because the exact string is found as is.

Is this a bug in SQL Server? If not, is this a normal behavior? If yes, is there a setting we can apply in the full text indexing definition to avoid those unexpected situations?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform