I'm using textarea to make available a large blank area for freeform typing (it's a problem management app). The idea is to be able to paste in log messages and other output and save it in a mysql database for future searching.

I'm using a 'text' field, 65k in size and using mysql_real_escape_string to process the text before putting it into the database.

The problem is it's stripping out all the \n's. Taking out the mysql_real_escape_string function doesn't make a difference.

Suggestions? I'd like to keep it searchable so turning it into a binary field isn't going to help (as far as I know anyway based on the mysql online docs).

Thanks.

Carl