在php.ini里面设置 default_charset = "utf8" //不能是”utf-8“
在使用PDO时:
$options = array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8';"); //不能是”utf-8“
$pdo = PDO($dsn, $username, $passwd,$options);
在使用mysqli时:
$mysqli = new mysqli ( $host, $user, $psw, $database );
$mysqli->set_charset('UTF8'); //不能是”utf-8“
html文件
<meta http-equiv=Content-Type content="text/html;charset=utf-8">
MySQL的配置文件:my.ini
[mysqld]
character-set-server = utf8
collation-server = utf8_unicode_ci