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

Filed under:
|
|

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.

  1. Adding the header to the XML sent to PHP from flash.

  2. Force the FLASH to use UTF-8 encoding in the preference options.

  3. 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

Related posts about flash

Related posts about languages