Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1338
  • Last Modified:

Special Characters in XML to avoid?

Are there any characters that should be avoided (besides the  < > & " '). I am trying to process data that has sections that start with a backslash "\" and contain multiple dollar signs "$". This data is failing the import. $MM56A:$F603 is some of the data.

Thanks!
0
p1800volvo
Asked:
p1800volvo
  • 2
1 Solution
 
Geert BormansCommented:
in PCDATA only <> and & should be escaped.
All the other data needs to be conforming the encoding
so having a single byte encode 'é' in a UTF-8 is not allowed

some binary characters are not allowed as welll: NUL, BELL, ....
if you are pushing binary data in your XML, you would better check the XML specification
http://www.xml.com/axml/testaxml.htm
for allowed characters
0
 
p1800volvoAuthor Commented:
The data is wrapped in CDATA. The $MM56A:$F603 section is actual text, not binary. Just need to ensure that it is not being misinterprited as another character set. We are importing under XML 1.0 but the database is not UNICODE, single byte characters only.

Thanks!
0
 
Geert BormansCommented:
well, then there should not be a problem.
Make sure that you make the XML encoding equal to the database encoding

cheers

Geert
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now