Solved

Special Characters in XML to avoid?

Posted on 2008-06-16
4
1,317 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
  • 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 50 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
RSS Feed Enclosure URL 1 124
How to obtain string using substring and indexOf function 11 60
Test ddwrt:UserLookup 1 65
XML XSLT If loop 4 26
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

810 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