I am working on a site where users are allowed to create their own little pages. They are not allowed to modify the entire page, but only the content in the page inside of their little frame.
This information will not only be plaintext, but formatted text returned from a WYSIWYG editor or other form of HTML editor text area. I’m not sure if the data returned from the editor will be with the format “[ b ] my text [/ b ]” or if it will use unicode symbols or something to tell where formatting begins and ends.
How should I store this text in the MySQL database? It will not be searched or anything, so search performance isn’t an issue. When it is brought out of the database, it will be as one large “chunk”.
