Groups | Blog | Home
all groups > flash data integration > november 2005 >

flash data integration : Dynamic Flash - CHARSET PROBLEM



artfabrique
11/13/2005 10:49:41 AM
I have troubles whith passing text which i get from MySQL database to FLASH
movie.

CASE 1
I have a PHP script which prints some text in UTF-8 encoding
for example:

<?php
print("text=BLA BLA BLA&text2=??? ??? ??? ???");
?>

in this case text and text2 (english and russian) displayed correctly.

CASE 2
I have a PHP script which prints some text in UTF-8 encoding and also print
some text which it takes from MySQL database
for example:

<?php
$id=$_GET['id'];

$result=mysql_query("SELECT text FROM news WHERE id='$id'") or
die(mysql_error());
$text=mysql_fetch_row($result);
$text=$text[0];

print("title=bla bla bla - ??? ??? ???&text_".$id."=".$text);
?>

in this case the database entry is in RUSSIAN language. AND in flash movie
text will be displayed INCORRECTLY but title with russian words will be
dislayed correctly.

I REALLY NEED HELP!!! WHY DOES STRINGS FROM DATABASE displayed incorrectly.
all files (php and html) encoded in UTF-8 (Unicode) encoding.sdfsf
artfabrique
11/14/2005 9:23:02 AM
I FOUND SOLUTION!
The problem was in phpMySQLadmin script.
The charset of this script was Cyrillic and so the encoding of the database
entry which i've made by this util was Cyrillic. All i had to do was to chanche
the charset in phpMySQLadmin options =)
AddThis Social Bookmark Button