Database transformation using xml
Few days ago I transfer a full sql database from one sever to another. When doing so, first I write the data in an XML file using asp. In this case, I've just write into a file. Then I copy that xml file into another server.
Now I read this file using asp XMLDom and submit data in the database.
Throughout the process the following three characters cause some problem.
&, '(quot) and a black block.
These characters make the xml document illigal(not valid). My question is how can i handle this file when i am writing xml from database using asp or php script.
My question is how can i handle this file when i am writing xml from database using asp or php script
i think when you write the data to xml, write that inside in CDATA section.or try to use a function to escape from these special characters in asp or php.