Apostrophe (') in Full-Text Search String

  • 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?

    Thanks

  • I'm exactly the same problem and have no idea where to start fixing it. Have you got the issue resolved?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply