Special Characters: Flash + PHP + MySQL

programming
1

Hi:

I made a small user registration and login system with Flash front-end, but when I try to write values with special characters to the db, I get something else. For example, an á is recorded as á.

I’ve found lots of information about issues like this, but couldn’t solve it yet.

  • In the swf file, I got System.useCodePage=true;. I create a loadVars object** **and send it to the db thru a php script using sendAndLoad with POST.

  • If I execute a query in the dB’s command line, the value is written correctly.

  • In PHP, I’m converting the string to utf8: $variable = utf8_encode($variable);

  • MySQL version is 4.1.21 standard, The character set and collation is **utf8_unicode_ci **and utf_8.

Well, I don’t know if this is enough to show what’s the problem, I’m really going crazy with this. Any help will be appreciated.

Thanks a lot, regards.