How to properly store formatted text in a database?

Question

Database

Good afternoon!
Can you please tell me how to properly store the text and its formatting in the database? For example, how are comments stored in the Toaster in the database, how is the saving and subsequent (reverse) scanning going?
I want to make something like an online text editor with formatting and with the ability to save the formatted document in the database. Just started to study the issue, tell me in which direction to dig?

Answer 1

Use BB code processing.
christian-seiler.de/projekte/php/bbcode/doc/en/cha...
In the database, everything is stored in the clear with tags, processing is at the time of "sweep". Forbidden tags are escaped, allowed ones remain and are processed on the client as expected.