Special characters are being displayed

cichlid

I'm experiencing a strange problem in displaying some text I have extracted from an XML file that I haven't had much success in solving.

I am retrieving some remote XML, placing it in an array, and extracting the data I need, then inserting that into a MySQL database so it can be manipulated and merged with other data.

Some of the data includes location names, such as the one below, which include foreign characters that have been translated into a special character. For some reason, these are actually being displayed in the form shown below. For example and ampersand appears as & and not as &.

C&#244;te d'Ivoire

Any ideas on how I can solve this, please?

Many thanks,

rincewind456

Run it through [man]html_entity_decode/man for PHP 4 >= 4.3.0, PHP 5 or [man]htmlspecialchars_decode/man PHP5

cichlid

That does the trick. Many thanks for your help!