# Saving form values using php&mysql : problem with the accents (charset?)

**URL:** https://forum.kirupa.com/t/saving-form-values-using-php-mysql-problem-with-the-accents-charset/322881
**Category:** Uncategorized
**Created:** [June 7, 2011, 12:12pm UTC](https://forum.kirupa.com/t/saving-form-values-using-php-mysql-problem-with-the-accents-charset/322881 "2011-06-07T12:12:46Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![grosbouff](https://avatars.discourse-cdn.com/v4/letter/g/7c8e57/32.png) [@grosbouff](https://forum.kirupa.com/u/grosbouff)
#### Post date: [June 7, 2011, 12:12pm UTC](https://forum.kirupa.com/t/saving-form-values-using-php-mysql-problem-with-the-accents-charset/322881/1 "2011-06-07T12:12:46Z")

</div>

Hi; I made a flash website where the user has to fill & save a form.  
Those values are sent to mysql through a php script.  
The problem is that the informations are not correctly stored (accents) :  
eg. my table shows “éric” instead of “éric”.

I guess this is a charset related problem.  
Do you have any idea of how to do this ?  
The html which includes my swf is UTF8(no BOM)

here’s my SQL table

```auto
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `games` int(5) NOT NULL,
  `firstname` text NOT NULL,
  `lastname` text NOT NULL,
  `facebook` varchar(50) NOT NULL,
  `password` text NOT NULL,
  `email` text NOT NULL,
  `ip` int(11) NOT NULL,
  `address` text NOT NULL,
  `city` varchar(100) NOT NULL,
  `zipcode` varchar(5) NOT NULL,
  `phone` varchar(25) NOT NULL,
  `spam` tinyint(1) default NULL,
  `terms` tinyint(1) default NULL,
  `time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

```

thanks !