The information is displayed as HTML, but I'd rather not store <br /> in database.

Is \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?