Does anyone know how to maintain text formats (i.e line breaks, double spaces, carrage returns) when adding text to a database.
for example:
"This is line 1 sentance 1. Sentance 2 after 2 spaces.
This ia a new parragraph."
does it involve escape characters? if so how?