Saving new Lines in database and Json

Question

I have this problem: I have an HTML textarea which is filled by the user. (And he can press The enter button to go on a new line). Then I take The value of The textarea using the command:

document.getElementById("textareaCommento")

And I pass The value to the servlet using an XmlHttpRequest. In The servlet I save this value in a database. Since this point I have no problems...

Then, in another part I want to get The values from The database. Using a servlet I make this query

Select * from comments

And I transform the results in json. Here I have The problem... The newline character makes my JSON string invalid. For example:

"Comment":"hello
Word"

How can I do? Thanks in advance!

score 2 · Accepted Answer · edited May 23 '17 at 11:48

2

You have to replace the \n character from database to something like <br/>

For the replace see replace \n and \r\n with <br /> in java

edited May 23 '17 at 11:48

Community

1
1

answered Oct 24 '12 at 07:39

MaVRoSCy

17,747
15
82
125

\n is the new line character. It is there – MaVRoSCy Oct 24 '12 at 07:46
When you query the database the \n and \r chars are also returned. It is very likely that you cannot see them but surely they are there – MaVRoSCy Oct 24 '12 at 07:47
really? I did not know! so before putting the string in json format I do character substitution \n with the sequence
? – Martina Oct 24 '12 at 08:13
yes , use the link i gave you ine my answer to replace also \r characters – MaVRoSCy Oct 24 '12 at 08:18
ok, the replace works, but when i put the text in a td field of a table, it shows
. it don't go on a new line...:( – Martina Oct 24 '12 at 08:22
I do the reverse process in the javascript page? – Martina Oct 24 '12 at 08:24
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/18510/discussion-between-mavroscy-and-marty) – MaVRoSCy Oct 24 '12 at 08:34

score 2 · Answer 2 · answered Oct 08 '18 at 00:15

2

this CSS worked for me,

white-space: pre-line;

answered Oct 08 '18 at 00:15

sean717

11,759
20
66
90

score 0 · Answer 3 · edited May 23 '17 at 12:21

0

You should be able to url encode your values so hello world would actually become "hello%20world", to do it in java see here:

Encoding URL query parameters in Java

To do it in javascript see here:

Encode URL in JavaScript?

edited May 23 '17 at 12:21

Community

1
1

answered Oct 24 '12 at 07:37

Grofit

17,693
24
96
176

Saving new Lines in database and Json

3 Answers3