use char(13) + char(10) in sql statement to insert new line.
Insert into <table name> (id,data) VALUES (’1′,’test’ + char(13) + char(10) + ‘line’);
use char(13) + char(10) in sql statement to insert new line.
Insert into <table name> (id,data) VALUES (’1′,’test’ + char(13) + char(10) + ‘line’);