XML file erroring due to certain characters in strings

Question

I have an XML file that pulls from a database. I'm getting an error on certain strings and URL's because it contains characters that the XML is treating like code and either gives a syntax error or says entity not defined. Is there a way, since the data is really a string, to set up the XML so when the data is in quotes, it ignores it as code and treats it like text? I created an example with the marker name and the URL having the errors. The marker name has the & sign and the URL has msa, ll, spn, and iwloc it doesn't like.

<?xml version="1.0" encoding="utf-8"  standalone="yes" ?>
<markers>
<marker name="C&O Canal Trail"
address=""
city=""
state=""
zip=""
image=""
width=""
height=""
lat="39.693978"
lng="-78.154822"
category="KML"
notes=""
url="https://maps.google.com/maps/ms?msid=209491726150360274926.0004e18eed520de4890e6&msa=0&ll=39.213103,-77.295685&spn=0.619262,1.540833&iwloc=0004e18eee21c28a5a313"
hike_distance=""
hike_trail_skill_level=""
hike_points_of_interest=""
Camping_Amenities=""
Camping_Best_Sites=""
Camping_Notes=""
/>
</markers>

Not sure what you mean, its generated as a text file from an access database, with an xml extension. — 2pourdrummer, Jul 17 '13 at 19:33

Tom · Accepted Answer · 2013-07-18T17:26:31.930

0

You need to XML encode the text, so replace:

& with &amp; 
< with &lt;
" with &quot;
' with &apos;
> with &gt;

It's better to use a library to do this that roll your own code.

edited Jul 18 '13 at 17:26

answered Jul 17 '13 at 19:32

Tom

43,583
4
41
61

I can't expect uses to enter data that way, and it also doesn't help with the URL that has msa, ll, smn and iwloc. – 2pourdrummer Jul 17 '13 at 19:36

score 0 · Answer 2 · edited May 23 '17 at 11:49

0

In XML, data contained inside a <[CDATA[ ... ]]> tag allows arbitrary character data. See What does <![CDATA[]]> in XML mean?

But won't work in attributes of tags.

edited May 23 '17 at 11:49

Community

1
1

answered Jul 17 '13 at 19:34

geocodezip

158,664
13
220
245

Not sure how that helps – 2pourdrummer Jul 17 '13 at 19:39

fenix · Answer 3 · 2013-07-17T19:55:46.623

Tom is right.

Here is your exact code converted.

<?xml version="1.0" encoding="utf-8"  standalone="yes" ?>
<markers>
<marker name="C&amp;O Canal Trail"
address=""
city=""
state=""
zip=""
image=""
width=""
height=""
lat="39.693978"
lng="-78.154822"
category="KML"
notes=""
url="https://maps.google.com/maps/ms?msid=209491726150360274926.0004e18eed520de4890e6&amp;msa=0&amp;ll=39.213103,-77.295685&amp;spn=0.619262,1.540833&amp;iwloc=0004e18eee21c28a5a313"
hike_distance=""
hike_trail_skill_level=""
hike_points_of_interest=""
Camping_Amenities=""
Camping_Best_Sites=""
Camping_Notes=""
/>
</markers>

For reference here are the XML reserved characters : http://msdn.microsoft.com/en-us/library/ms145315(v=sql.90).aspx

As a recommendation, I would suggest that you scrub the data as it's coming in from the database before it hits the XML Reader/Writer and do a replace on all of the reserved characters found in your data.

Alternatively you can do this replace to your data inside your database - but then you'd be only patching this problem for XMLRead/Write instead of doing it dynamically for your specific implementation.

XML file erroring due to certain characters in strings

3 Answers3