# Special Characters: Flash + PHP + MySQL

**URL:** https://forum.kirupa.com/t/special-characters-flash-php-mysql/213290
**Category:** programming
**Created:** [January 18, 2007, 12:37pm UTC](https://forum.kirupa.com/t/special-characters-flash-php-mysql/213290 "2007-01-18T12:37:45Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![durreimon](https://avatars.discourse-cdn.com/v4/letter/d/d26b3c/32.png) [@durreimon](https://forum.kirupa.com/u/durreimon)
#### Post date: [January 18, 2007, 12:37pm UTC](https://forum.kirupa.com/t/special-characters-flash-php-mysql/213290/1 "2007-01-18T12:37:45Z")

</div>

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.