美文网首页
php mysql 写入乱码

php mysql 写入乱码

作者: 9682f4e55d71 | 来源:发表于2018-09-21 15:08 被阅读8次

    读取正常,写入乱码,则需要加上下面的两行才行。

    mysql_query("set character set 'utf8'");//读库  
    mysql_query("set names 'utf8'");//写库
    
    -- 查看
    MySQL [zencart]> show variables like '%char%';
    +--------------------------+----------------------------+
    | Variable_name            | Value                      |
    +--------------------------+----------------------------+
    | character_set_client     | gbk                        |
    | character_set_connection | gbk                        |
    | character_set_database   | utf8                       |
    | character_set_filesystem | binary                     |
    | character_set_results    | gbk                        |
    | character_set_server     | utf8                       |
    | character_set_system     | utf8                       |
    | character_sets_dir       | /usr/share/mysql/charsets/ |
    +--------------------------+----------------------------+
    8 rows in set (0.04 sec)
    
    -- seesoin 级别
    set character_set_database=gbk;
    set character_set_server=gbk;
    
    -- 进程级别(重启msyql服务后会失效)
    set global character_set_database=gbk;
    set global character_set_server=gbk;
    
    
    -- 永久级别(重启mysql服务后依然有效)
    [mysqld]
    character-set-server=utf8 
    
    [client]
    default-character-set=utf8 
    
    [mysql]
    default-character-set=utf8
    

    相关文章

      网友评论

          本文标题:php mysql 写入乱码

          本文链接:https://www.haomeiwen.com/subject/vloanftx.html