执行查询前,先执行如下语句(适用于PHP + Mysql 4.1): SET CHARACTER SET utf8<?php $db = new DB_Sql(); //连接数据库 $db->connect("test","localhost","root",""); //执行查询 $db->query("SET CHARACTER SET utf8"); $sql = "select * from tablename"; $sql .= "where id='1'"; $db->query($sql); ...... ?>
SET CHARACTER SET utf8<?php
$db = new DB_Sql();
//连接数据库
$db->connect("test","localhost","root","");
//执行查询
$db->query("SET CHARACTER SET utf8");
$sql = "select * from tablename";
$sql .= "where id='1'";
$db->query($sql);
......
?>