将换行符从XML插入数据库

Question

I am trying to parse this xml document in which a newline is required for certain fields and must be inserted into the database with the newline. But I've been running into problems.

1)First Problem: Character

The first problem I had was using the like below.

<javascript>jquery_ui.js
shadowbox_modal.js
user_profile.js
tablesorter.js</javascript>

The problem was in the database the field came out ot be jquery_ui.js shadowbox_modal.js ... and when output into html it was jquery_ui.jsnshadowbox_modal.jsn...............

2) Then I tried actually having newlines in the xml

<javascript>jquery_ui.js
           shadowbox_modal.js
           user_profile.js
           tablesorter.js</javascript>

The problem was the output become %20%20%20%20%20%20%20%20%20%20shadowbox_modal.js, and so forth. So how can I get a newline to hold from xml when entered into a database and then output with the newline still?

Answer 1

Remove the spaces from your second example.

You probably entered a tab and/or spaces for readability, but these get inserted too.

%20 is an urlencoded space.