Finding what kind of line endings are stored in the database

I have a form on my website where users can enter multiple paragraphs of text which get inserted into a mySQL database. What is the best way in PHP to show the hidden line endings like
as well as \r ? I ask this because I go in to my database client and enter paragraphs myself, and it is apparently using different line endings than what the html form is using.

I need to figure this out so I can use a PHP function called nl2p, which takes text from the database and puts it into proper html paragraph tags. I need all the paragraphs in my database to consistently use the same type of line endings for this function to work correctly.


this is why [FPHP]nl2br[/FPHP] was added :wink: