MySQL to XML - charset problems
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 |
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> Code:
<blah> |
All times are GMT -5. The time now is 10:56 PM. |