Post reply

Fulltext with Dot(.) search

  • August 30, 2011 at 3:10 am

    #256477

    Dear User

    I have challenge in FullText search:

    Requirement is: if user will search “b.com” result should be same a “B.COM”

    Result we are getting is totally different.

    I did some investigation which tells me It is not because of case-sensitive but because of “dot(.)” the reason is we are getting a same result for “com” and “COM” but not for “b.com” and “B.COM”

    Anyone can help on this?

    CONTAINSTABLE (DATA_TABLE,cText,N'"B.COM"')

    CONTAINSTABLE (DATA_TABLE,cText,N'"b.com"')

  • August 31, 2011 at 1:02 am

    #1375316

    I may be wrong on this, but I'm pretty sure that SQL Server full-text search uses the full stop as one of its word delimiters--in other words, if you have the text b.com in your file, the full-text index will have b and com in it, but not b.com. I don't think there's any way to change this behaviour either, sorry.

  • April 3, 2012 at 10:56 am

    #1468356

    Try searching by '"b..com"' and let me know your results.

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

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