[philip.j.fry]

For future reference there are special characters you need for newlines, these differ between windows, macs and *nixes.

There are two escape characters that you need to know, \n is the line feed (LF) character and \r is the carriage return (CR) character.

*nixes use just the LF character for a newline: e.g "This\nIs\nMy\nSentence"

Windows uses the CR followed by the LF character: e.g. "This\r\nIs\r\nMy\r\nSentence"

Macs use just the CR. e.g. "This\rIs\rMy\rSentence"

These are normal characters and will store fine in a database. Most modern programming languages have a constant that represents the newline character for the system you are using.