Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Apostrophe (') in Full-Text Search String Expand / Collapse
Posted Wednesday, November 4, 2009 3:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 5, 2009 3:21 PM
Points: 1, Visits: 10
We use MS SQL Server 2005 full-text search. Our stored procedure for the search accepts a parameter which is the search string the user submitted using our site's search page. We use CONTAINSTABLE and FREETEXTTABLE.

The problem is when the user submits a search string with an apostrophe in it (ex. Foster's).
A search for "Foster's" does return the record which has the entry "Foster's" and also all Foster (without the apostrophe ).

However, searching for "O'Connor" will return the "O'Connor" record only and not any other Connor.

My problem now is: How do I make the fisrt example to works like the second one? How can I make my full-text search support the apostrophe? If it is indeed not possible, can you provide a link to an article that concludes/proves that MS SQL Server 2005 full-text search does not support the apostrophe in the search string?

Post #813896
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse