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