UTF-8 encoding problem with flash mysql and php
Posted
by
alibhp
on Game Development
See other posts from Game Development
or by alibhp
Published on 2011-01-09T07:10:04Z
Indexed on
2011/01/09
7:58 UTC
Read the original article
Hit count: 431
Hi,
As you may know, I am programming an on-line game using FLASH. I am connecting my FLASH 8 movie with MySQL database through PHP. I am doing very good in that, and I have everything working fine.
The problems come when I am trying to insert (Using the INSERT SQL func) data to the database that are non-english. In other words, UTF-8 data.
I red a lot of articls about that stuff and found and apply the fallowing: 1. In PHP4, you need to tell the PHP to use UTF-8 when using the xml_parser_crater() func, however, in PHP5 that is done automatically. Even though I told PHP5 to use the UTF-8 when calling the func.
Adding the header to the XML sent to PHP from flash.
Force the FLASH to use UTF-8 encoding in the preference options.
Set the encoding in MySQL to UTF-8 (utf8_unicode_ci with InnoDB engine). I can read and insert the other language data correctly in the phpadmin as well.
I did all that in my coding, and still I can't insert such data.
one more strange thing is that, when I use the same link, that the FLASH using, with the XML, that the FLASH creating, on the browser (google chrome), I got the data inserted right in the database!!!!!
I am about to get crazy about that stuff, What am I missing? what cause the problem?
Thank you in advance.
© Game Development or respective owner