 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / July 2008'"n*"' prefix search
Can you tell me why a prefix search like: SELECT <column_list> FROM <table> WHERE CONTAINS(<column1>, '"n*"') (<column1> is a "nvarchar") returns not only records containing text beginning with "n", but also numeric data? For example, this search will return "Normandin Mercier Grande Champagne Peraudier 750ML" but also "2001 Pillar Rock Cabernet Sauvignon 1.5L", or "Tormore 12-Year Scotch 750ML". See a related question here: http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3532785&SiteID=17 Diana, I believe that Hilary explained this in his earlier post. - Indexed numbers such as "123" are stored in the fulltext index as "NN123". - This behavior is controlled by the wordbreakers. To prove this to yourself, you can do the following queries: SELECT <column_list> FROM <table> WHERE CONTAINS(<column1>, '"nn123"') SELECT <column_list> FROM <table> WHERE CONTAINS(<column1>, '"123"') You will get the same result set. RLF > Can you tell me why a prefix search like: > SELECT <column_list> FROM <table> WHERE CONTAINS(<column1>, '"n*"') [quoted text clipped - 6 lines] > See a related question here: > http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3532785&SiteID=17 Thank you Russell, Hilary. Unfortunately this behavior is not clearly documented anywhere - neither in BOL, nor in other resources. Diana > Diana, > [quoted text clipped - 23 lines] > > See a related question here: > > http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3532785&SiteID=17 Diana, I would have to agree that I could not find it documented. The only mention a couple of minutes of googling gave me was in this post: http://www.sqlskills.com/blogs/simon/CategoryView,category,Full%2BText.aspx Experimentation gave me the rest. RLF > Thank you Russell, Hilary. > Unfortunately this behavior is not clearly documented anywhere - neither [quoted text clipped - 33 lines] >> > See a related question here: >> > http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3532785&SiteID=17 you need to get one of the earlier Windows SDKs which shipped with Filtdump and lrtest. These would allow you to see how words are tokenized for indexing by the iFilters and Word Breakers. > Thank you Russell, Hilary. > Unfortunately this behavior is not clearly documented anywhere - neither [quoted text clipped - 33 lines] >> > See a related question here: >> > http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3532785&SiteID=17 |
Reply to this Message |
 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
|
©2008 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.