Becouse I’ve received a lot of emails asking me how can AS3FlexDB can select UTF8 data from MySQL i have decided to write a post and explain how you can load UTF8 data from MySQL in Flex.
There are three steps you must done to accomplish this:
Setup your MySQL table fields to support UTF8. You can do this by changing your collation to utf8_general_ci
Edit the AS3FlexDB service ( database.php ) on function open($strUser, $strPass, $strHost) line 37 after
$rsConnectionID = @mysql_connect($strHost, $strUser, $strPass);
this function will set UTF8 character set for the current connection.
Edit AMFPHP gateway.php file. The gateway.php file is the bridge between your flash .swf file and AS3FlexDB service (database.php). In this file all you need to change is the setCharsetHandler method.
$gateway->setCharsetHandler(”utf8_decode”, “ISO-8859-1″, “ISO-8859-1″);
$gateway->setCharsetHandler( “none”, “ISO-8859-1″, “ISO-8859-1″ );
and this is all. If you have done everything right you can now load UTF8 data from MySQL.
If you want to read more about character set in AMFPHP you can check this tutorial.