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
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 !