?
Solved

Special Characters in XML to avoid?

Posted on 2008-06-16
4
Medium Priority
?
1,326 Views
Last Modified: 2010-05-18
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
Comment
Question by:p1800volvo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 21801568
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
 
LVL 1

Author Comment

by:p1800volvo
ID: 21802928
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
 
LVL 60

Accepted Solution

by:
Geert Bormans earned 200 total points
ID: 21815724
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

Not sure which OpenStack Certification to get?

So you’ve realized you might want to get certified in OpenStack, but you’re not sure what the benefits might be or even which one you should take. You know there are several certification courses you can choose from, but how do you know which one is right for you?

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Client Need Led Us to RSS I recently had an investment company ask me how they might notify their constituents about their newsworthy publications.  Probably you would think "Facebook" or "Twitter" but this is an interesting client.  Their cons…
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question