我晕,怎么就不知道搜索一下呢?查询之前执行:SET NAMES utf8(GB2312) 另一种方法:SET CHARACTER SET utf8 (GB2312)$db = new DB_Sql();$db->connect(__DB_DATABASE,__DB_HOSTNAME,__DB_USERNAME,__DB_PASSWORD); $db->query("SET CHARACTER SET utf8");$sql = "SELECT `id`,`name` FROM `table_name`"; $sql .= "ORDER BY `id` ASC";$db->query($sql); ...... $db->free();
urlencode这个可以,不过笨了点。
字符集怎么改都没有用
干脆换回了4.0
另一种方法:SET CHARACTER SET utf8 (GB2312)$db = new DB_Sql();$db->connect(__DB_DATABASE,__DB_HOSTNAME,__DB_USERNAME,__DB_PASSWORD);
$db->query("SET CHARACTER SET utf8");$sql = "SELECT `id`,`name` FROM `table_name`";
$sql .= "ORDER BY `id` ASC";$db->query($sql);
......
$db->free();