# SQLite new line in data

**URL:** <https://forum.kirupa.com/t/sqlite-new-line-in-data/307027>\
**Category:** flash\
**Created:** [March 26, 2010, 11:05am UTC](https://forum.kirupa.com/t/sqlite-new-line-in-data/307027 "2010-03-26T11:05:46Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![kadaj](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/kadaj/32/9061_2.png) [@kadaj](https://forum.kirupa.com/u/kadaj)\
**Post date:** [March 26, 2010, 11:05am UTC](https://forum.kirupa.com/t/sqlite-new-line-in-data/307027/1 "2010-03-26T11:05:46Z")

</div>

## In which way should one store data in a SQLite database so that when it is displayed in a textArea, new lines appear.

eg:  
The output must be like this -\>  
First line.  
Second Line.

## Usually I get -\> First Line. Second Line. - in one single line And if I add First Line. Second Line. to the data in the database it just displays along with the .

So what actually is the new line character that must be put into the data I store in the SQLite database so that the output in the textArea gets formatted accordingly.

Thanks.