Storing formatted text, not in HTML?!

[lifeworks]

Simple issue...

If my website is storing text in a database (MySQL) - and will ordinarily be outputted in good ol' HTML... but possibly via XML, or JSON... how do I store the text, allowing for eg. paragraph breaks, but not using HTML to format it??

lworks

[Lsmjudoka]

Well, since nobody else has replied, I'll just throw this out there. You can use a custom markup language, that can then be easily translated to whichever language necessary. BBcode is an example of a markup language that gets translated into HTML. Make a set of tags for each format option you need.