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

Popular posts from this blog

objective c - Change font of selected text in UITextView -

php - Accessing POST data in Facebook cavas app -

c# - Getting control value when switching a view as part of a multiview -