sql server - How to store data from a richtexteditor to accommodate searches? -
we're considering adding rich text editing our system. understand we'll heavily tagged string our textareas. wonder database searches text within data. there might non-html tags containing versioning comments or other stuff wouldn't want searched.
how implemented? store data twice, once tags , once without? or there sql server tools skip tags during searches won't kill performance-wise?
(we're on sql server 2005 now, moving 2008)
i use full text search , include html tags stopwords. can read more these here.
good luck!
Comments
Post a Comment