The information is displayed as HTML, but I'd rather not store
<br /> in database.
\n the best choice?
Personally, I've found that
\r\n has a tendency to are more effective.
Why don't you store them as
\n and perform a replace whenever you query the database to whatever character or character (as well as
<br />) that you would like?