I need to create an XML for a third party so we can share some XML articles.
I want to store each node in a data base field using SQL Server 2008
I will input the html with an html editor through a webform (asp.net)
I need the output to be well formed xml where special characters are properly escaped.
Do I need to encode the html when we save it?
What would be the best XML encoding to use on the feed?
We don't have a lot of experience of this so advice would be really helpful.