Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Full text Search HTML formatted text

Unanswered Full text Search HTML formatted text

  • Monday, April 12, 2010 12:59 PM
     
     
    Sign In to Vote
    0

    hi,

    how to use Full-Text Search to search in an HTML Formatted Text

    is there any links

    is it complex task or it just need some settings?

    Regards,

    Ahmed Salah
    • Moved by Alex Feng (SQL)Moderator Wednesday, April 14, 2010 3:20 AM move to an appropriate forum (From:SQL Server Database Engine)
    •  
     

All Replies

  • Monday, April 12, 2010 1:23 PM
     
     
    Sign In to Vote
    0

    Salah,

    Should have asked in Full Text Search forum.  

    You can store your HTML as varbinary(MAX) column and documnet type as .html or .htm

    but in my opinion some of the html tags need to be omitted as noise words like </br> or </p>

     

    • Edited by Chirag Shah Monday, April 12, 2010 2:24 PM content
    •  
     
  • Tuesday, April 13, 2010 11:49 AM
     
     
    Sign In to Vote
    0

    hi Chirag,

    thanks alot for your reply.

    is it a way to know which tags full text search will omit

    and which ones i have to Add as noise words

    Regards,

    Ahmed Salah
    • Edited by A.Salah Tuesday, April 13, 2010 11:51 AM the word add peared as aline
    •  
     
  • Wednesday, April 14, 2010 10:38 AM
     
     
    Sign In to Vote
    0
    full text search will not index html tags if you use the document type extension for html.
    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941