使用PHP+MYSQL时遇到过字符乱问题,解决方法:
在mysql_connect后面加一句SET NAMES UTF8,即可使得UTF8的数据库消除乱码,对于GBK的数据库则使用SET NAMES GBK,代码如下:
1 2 3 | <div>
<span style= "color: #008080;" >1</span> <span style= "color: #000000;" > $mysql_mylink </span><span style= "color: #808080;" >=</span><span style= "color: #000000;" > mysql_connect( $mysql_host , $mysql_user , $mysql_pass ); <br></span><span style= "color: #008080;" >2</span> <span style= "color: #000000;" >mysql_query( "</span><span style=" color: #0000ff; ">SET</span><span style=" color: #000000; "> NAMES </span><span style=" color: #ff0000; ">'</span><span style=" color: #ff0000; ">GBK</span><span style=" color: #ff0000; ">'</span><span style=" color: #000000; ">" ); </span>
</div>
|
登录后复制
数据库字符集为utf-8
连接语句用这个
1 2 3 | <div>
<span style= "color: #008080;" >1</span> <span style= "color: #000000;" >mysql_query( "</span><span style=" color: #0000ff; ">SET</span><span style=" color: #000000; "> NAMES </span><span style=" color: #ff0000; ">'</span><span style=" color: #ff0000; ">UTF8</span><span style=" color: #ff0000; ">'</span><span style=" color: #000000; ">" ); <br></span><span style= "color: #008080;" >2</span> <span style= "color: #000000;" >mysql_query( "</span><span style=" color: #0000ff; ">SET</span><span style=" color: #000000; "> </span><span style=" color: #0000ff; ">CHARACTER</span><span style=" color: #000000; "> </span><span style=" color: #0000ff; ">SET</span><span style=" color: #000000; "> UTF8" ); <br></span><span style= "color: #008080;" >3</span> <span style= "color: #000000;" >mysql_query( "</span><span style=" color: #0000ff; ">SET</span><span style=" color: #000000; "> CHARACTER_SET_RESULTS</span><span style=" color: #808080; ">=</span><span style=" color: #000000; ">UTF8</span><span style=" color: #ff0000; ">'</span><span style=" color: #ff0000; ">" ); </span>
</div>
|
登录后复制