php pdo 设置默认字符集charset
$dbms = ‘MySQL’; //数据库类型 $host = ‘localhost’; //数据库主机名 $dbName = ‘ijishequ’; //使用的数据库 $user = ‘root’; //数据库连接用户名 $pass = ‘’; //对应的密码 dsn = " dsn = " dsn="dbms:host=host; dbname=host; dbname=host; dbname=dbName; charset=utf8"; try{ dbh=newPDO( dbh = new PDO(dbh=newPDO(dsn, $user, $pass); //初始化一个PDO对象 $result = $dbh->query(‘SELECT * from goods’, PDO::FETCH_ASSOC)->fetchAll(); } catch (PDOException $e) { die ("Error!: " . $e->getMessage() . “ ”); }
在dsn后面加入 charset=utf8