mysql(服务器版本: 5.0.51b-community-nt-log)乱码，查了很多资料也不行,请高手指点

用到啥就学啥 2009-03-25 05:06:40

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_ci

7.我用的是(简写)$db=new mysqli();
$insert="insert into table values"
$result=$db->query($insert);
请高手帮助!

...全文

256 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

hyfufo 2009-03-30

打赏
举报

还是字符集不一致的问题.

用到啥就学啥 2009-03-26

打赏
举报

找到答案了。
$conn=new mysqli("localhost","root","root","db_database09");

$conn->query("set names uft8");

这样就可以了！

用到啥就学啥 2009-03-26

打赏
举报

谢谢。但是如果使用面向对象的mysqli这种语句怎么办呀?

ljf_ljf 2009-03-25

打赏
举报



    $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();