Take the 2-minute tour ×

To keep this simple, I intent to store some html based content that is created by the end user. So a table like the following

create table Content

Now, the HTML comes from let's say a CKEditor. Is it good practice to also store the plain text version of the content so that full text search or whatever search mech can more easily find the content? As shown below.

table Content
share|improve this question
Have a look at this. developmentnow.com/blog/2006/08/12/… –  DON Jan 10 '13 at 6:01
having 0% accept rate wont gonna help you much in getting answer. –  viki Jan 10 '13 at 6:03
You could go over your past questions and formally accept answers where possible. Accepting own answers is all right as well, all the more so when they get recognition such as this. :) –  Andriy M Jan 10 '13 at 6:26
html itself is plain text. –  Uğur Gümüşhan Feb 13 '13 at 23:39
add comment

1 Answer

As pointed out in the comments: absolutely! There are formatting strings and HTML tags that don't pertain to any conceivable search (unless you're looking for formatting in particular, e.g., someone uses AliceBlue).

Also, your indeces are likely to be more efficient, speeding up your searches, if you're not throwing in "junk" like HTML tag names.

share|improve this answer
add comment

Your Answer


