MySQL to XML

Boby · 04-18-2005, 08:29 AM

Hello!

I have to transfer all informations from a huge MySQL table to an XML file. The MySQL charset is ISO-8859-1 [german] . There are also some special characters, most of them are russian or bulgarian letters, <= in one character [I'm not able to display it here too], and so on. When I try to read from the XML file with an XML parser in PHP or just to display the file in Firefox or another browser, I get errors because of this chars. Is there a way to delete all this chars or replace them with good ones with an PHP script? I also tried to set the XML encoding to UTF-8 but I get the same errors.

Thank you!
Boby

deiussum · 04-20-2005, 08:22 AM

Not sure about extended character sets offhand, but the following standard ASCII characters need to be translated as so:

< becomes <
> becomes >
& becomes &amp;

For instance, if you have the following XML:

Code:

<blah>
    <b1>Me & You</b1>
    <b1>2 > 1</b1>
    <b1>2 < 4</b1>
</blah>

It would need to be encoded as so:

Code:

<blah>
    <b1>Me &amp;amp; You</b1>
    <b1>2 &gt; 1</b1>
    <b1>2 &lt; 4</b1>
</blah>

Edit: Had to encode my &amp; twice above because the HTML was translating it!