1.用phpmyadmin插入中文无乱码.
2.php的语句插入中文出现乱码.注php中已经是utf-8:<meta http-equiv="Content-Type" content="text/html; charset="utf-8" />
3.mysql版本5.0.51b.
4.mysql的变量
character set client utf8
character set connection utf8
character set database utf8
character set filesystem binary
character set results utf8
character set server utf8
character set system utf8
character sets dir d:\AppServ\MySQL\share\charsets\
collation connection utf8_unicode_ci
(全局值) utf8_general_ci
collation database utf8_general_ci
collation server utf8_general_ci 5.MySQL 字符集: UTF-8 Unicode (utf8)6.MySQL 连接校对UTF8_unicode_ci7.我用的是(简写)$db=new mysqli();
$insert="insert into table values"
$result=$db->query($insert);
请高手帮助!
2.php的语句插入中文出现乱码.注php中已经是utf-8:<meta http-equiv="Content-Type" content="text/html; charset="utf-8" />
3.mysql版本5.0.51b.
4.mysql的变量
character set client utf8
character set connection utf8
character set database utf8
character set filesystem binary
character set results utf8
character set server utf8
character set system utf8
character sets dir d:\AppServ\MySQL\share\charsets\
collation connection utf8_unicode_ci
(全局值) utf8_general_ci
collation database utf8_general_ci
collation server utf8_general_ci 5.MySQL 字符集: UTF-8 Unicode (utf8)6.MySQL 连接校对UTF8_unicode_ci7.我用的是(简写)$db=new mysqli();
$insert="insert into table values"
$result=$db->query($insert);
请高手帮助!
$conn = mysql_connect("192.168.1.133", "root", "123456") or
die("Could not connect: " . mysql_error()); $program_char = "utf8"; $conn.mysql_select_db("test");
//$conn.mysql_query('SET @@character_set_results = "'.$program_char.'"');
mysql_set_charset($program_char,$conn);
$charset = mysql_client_encoding($conn);
printf ("current character set is %s <br>", $charset);
$result = mysql_query("SELECT id, task_no,pack_path FROM tb_workplan where id = 1 ",$conn);
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
printf ("ID: %s <br> task_no: %s <br> pack_path :%s <BR>", $row["id"], $row[1], $row["pack_path"]);
}
$conn.mysql_free_result($result);
$conn.mysql_close();楼主可以参考上面内容。
$conn=new mysqli("localhost","root","root","db_database09");$conn->query("set names uft8");
这样就可以了!