Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 717
  • Last Modified:

How to make sql 2005 full text search index short words

Would anyone have a suggestion on how to make SQL 2005 FTS index words like C# or C++? I know I could remove C (c) from noise words but FTS still ingores # and ++.

I have a text field that contains people's resumes (blobs) and inability to find C#, C++ et al is quite a show stopper.

  • 2
1 Solution
lcdataAuthor Commented:
Just to add to this: I also have an xml field, FT indexed as well - same problem.

If there's no solution with 2005, would anyone know if 2008 offers more flexibility (been looking on MS site, but their text is like IBM's - no one understands anything). How about alternative solutions? Something that well integrates with SQL 2005?

Anthony PerkinsCommented:
FT Search considers # as a word breaker.  However see this article:

Generally, the words broken at index time are stored in the catalogs exactly as broken by the word breakers. However, there are some exceptions. For example:

c# is indexed as c (if c is not in your noise word list, see more on noise word lists later), but C# is indexed as C# (in SQL 2005 and SQL 2000 running on Win2003 regardless if C or c is in your noise word list). It is not only C# that is stored as C#, but any capital letter followed by #. Conversely, c++ ( and any other lower-cased letter followed by a ++) is indexed as c (regardless of whether c is in your noise word list).

If that does not work for you will have to get creative.
lcdataAuthor Commented:
thank you for your time.

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now