I have a script that retrieves text from a Mysql db. The PHP script creates an XML file from it and the XML file is then parsed in Flash MX 2004.
But there's trouble with certain characters (French accented chars or even a simple single quote). Now when I just echo out the text, it gets displayed correctly in a browser when the encoding is set to Western-European.
I tried to use
$title = utf8_encode($title);
before writing the contents to the file, but PHP doesn't seem to encode the characters. If I drag the created XML file into the browser, the characters are not displayed correctly (with UTF8 encoding auto-selected in Explorer).
I tried to follow some advice on Flash forums and force Flash to interpret the string as non-UTF8 by setting the system.useCodepage = true. But since I use a Japanese Operating system, the text in Flash is misinterpreted.
Where's the problem?
utf8_encode
writing the UTF8 XML file
THANX
