# Å,Ä,Ö Cant get them to work?! :(

**URL:** <https://forum.kirupa.com/t/a-a-o-cant-get-them-to-work/135296>\
**Category:** Uncategorized\
**Created:** [January 26, 2005, 9:06am UTC](https://forum.kirupa.com/t/a-a-o-cant-get-them-to-work/135296 "2005-01-26T09:06:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![quackpack](https://avatars.discourse-cdn.com/v4/letter/q/8e7dd6/32.png) [@quackpack](https://forum.kirupa.com/u/quackpack)\
**Post date:** [January 26, 2005, 9:06am UTC](https://forum.kirupa.com/t/a-a-o-cant-get-them-to-work/135296/1 "2005-01-26T09:06:29Z")

</div>

Hello!  
I have used a script that get info from my MySQL server and then diplay it, it generates an XML file and here is my problem:

After it have recceved the info from the myslq server it displays everyting correct but there is one problem… no matter what I have tryed it just wont show Å,Ä,Ö… i have tryed different UTF-8, encodings, including in the php an function that replaces the Å,Ä,Ö with the correct html code: å ä ö that is used to display these words… but nothing works… I hope there is some flash guru here that can help me with this!

here is the php code that generates the XML file that Flash read:

\<?php  
#\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
#**XML OUTPUT  
#**\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

include(‘admin/functions.php’);  
connect(‘x’, ‘x’, ‘x’, ‘localhost’);  
$query = ‘SELECT id, author, title, body, FROM\_UNIXTIME(timestamp, ‘%M %D %Y’) date\*\*\*  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*_ **FROM flash\_news** _  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*LIMIT 20’;

$result = mysql\_query($query);

$nl = "  
";

\*\*\*\*echo ‘\<?xml version=“1.0” encoding=“UTF-8”?\>’ . $nl;  
\*\*echo ‘\<ROOT\>’ . $nl;

* * *

while($r = mysql\_fetch\_array($result)){

* * *

echo ‘\<news id="’ . $r[‘id’] . ‘" title="’ . stripslashes2($r[‘title’]) . ‘" date="’ . $r[‘date’] . ‘" author="’ .

stripslashes2($r[‘author’]) . ‘"\>’ . $nl;  
\*\*\*\*echo ‘\<body\>\<![CDATA[’ . stripslashes2($r[‘body’]) . ‘]]\>\</body\>’ . $nl;  
\*\*\*\*echo ‘\</news\>’ . $nl;

* * *

* * *

}

echo ‘\</ROOT\>’ . $nl;

?\>

plzzz help im loosing my mind here! ☹