Accented Characters

Hi All
I m sorry but this is not entirely a PHP issue but has PHP as one of the players.

I ve created a site in flash which gets its data from an XML file generated from the CMS (in PHP) and shows it. This XML file is generated by grabbing data from MySQL.

Inside flash I m using textfields that show htmlText so that it doesnt screw up on apostrophe etc. Also I run a loop on th incoming nodes to remove extra carriage returns.

Everything works fine except for foreign characters or the accented characters.

I cannot use a text file instead of an XML file as its a very big site related to artists(painters) hence there are many names with such characters. There is a lot of data coming in and I simply cannot keep allotting text files for even the name of the artist. I m sure i can do it that way but its too late now to consider that solution.

is there some way I can display these characters inside of Flash? With UTF-8, the characters were garbled in the XML itself and thus did not even make it to Flash.

I tried using htmlentities and then bring it inside but it shows the html entity in the format é and not é

I m currently using iso-8859-1 which at leasts gets the characters correctly inside the XML but in the Flash it doenst work.

In flash I have tried using System.useCodePage = true yet no luck

Any help is much appreciated
Thanks in advance and sorry for a not 100% php problem... but PHP plays a big part in it. Its creating the XML file in question!

This Forum is magical.... i submitted the query and in seconds i stumbled upon the solution!!!

Well it may not be the perfect solution but here goes

System.useCodePage = true *MUST* be the first line of the actionscript code ( i had put it in the scene which loads after the preloader)

I simply put it into th preloader and it worked...