XML cant be displayed in IE/Firefox

lucky_php

My php is generating an XML file from data in SQL server.

The data cotains special character -hyphen like
'Notes-this is...'

This XML file with special char is not geting displayed on IE /Firefox correctly.
I cant change the data or XML files.

I am using PHP and ajax to access the data.
and i am not able to debug ( with echo)my scripts because of ajax.

Somebody please suggess me the workaround of this .

Thanks

NogDog

If the text is data between XML opening and closing tags, then output it as CDATA:

echo "<tag_name><![CDATA[" . $text_to_be_output_here . "]]></tag_name>\n";

lucky_php

No My data is exported from a SQL server Stored through a stored procedure .and XML file is generated and written on background with AJAX session.
Thats how i cant see and debug it.

Data in table contains special characters apostrophe,hyphen.When saved xml file is opened in IE/FF doesnt display correctly bcoz of those characters.
Please suggest me the workaround.

Weedpacket

lucky_php wrote:
Data in table contains special characters apostrophe,hyphen.

Those aren't special characters in XML. Well, maybe the apostrophe is, but only inside single-quoted attribute values.

Of course, if the XML isn't well-formed, and you can't change the XML, then there's nothing you can do to make the XML well-formed so that browsers can display it.