hey all~!

I wish to insert comments inside a mysql database column which is a varchar(255) type. I'm not sure where to look to solve my problem, I even tried using some modules like Text::Wrap, but that doens't help much with this.

My problem is not when I insert a comment. For example, if the comment typed out on the textarea field looks like this:

This is a sample comment being inserted into a MySQL DB.  I would like
+ to format things correctly when being edited.

This is the 2nd "paragraph", or sentence after the line above this one
+.
[download]

Now when I insert it, the format is fine. But lets say I try to edit this comment, and I add the word "Hello" at the very end, then the comment will look like this:

This is a sample comment being inserted into a MySQL DB.  I would like
+ to format things correctly when being edited.



This is the 2nd "paragraph", or sentence after the line above this one
+. Hello
[download]

Notice how it adds two whole new line breaks between the first one? How do I remove that extra space? What is causing it too add those new lines?

I want to allow new lines to indicate a new paragraph, so I don't want to do a regex that removes all \n's ?

Is there anyway I can solve this with a perl regex?

thank you!