&lt;code&gt;
// conversion de la base
$sql1 = &quot;ALTER DATABASE heartcake CHARACTER SET UTF8&quot;;
$qid = mysql_query($sql1);
// conversion de la table
$sql1 = &quot;ALTER TABLE fan CHARACTER SET UTF8&quot;;
$qid = mysql_query($sql1);
// conversion des colonnes
$sql1 = &quot;ALTER TABLE fan CONVERT TO CHARACTER SET UTF8&quot;;
$qid = mysql_query($sql1);
&lt;/code&gt;