用php取mysql的值,在网页里看是,中文是5位utf8的编码,不是中文字.
请问是怎么回事?mysql运行show variables like '%char%';结果如下
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 utf8php这么写的
$conn = mysql_connect("localhost", "root", "1");
mysql_select_db("123", $conn);
mysql_query("set names 'utf8'");
$sql = "select * from 123.abc";
$result = mysql_query($sql);
$res1= mysql_fetch_array ( $result, MYSQL_NUM) ;
echo json_encode ( $res1 );
mysql_close($conn);
请问是怎么回事?mysql运行show variables like '%char%';结果如下
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 utf8php这么写的
$conn = mysql_connect("localhost", "root", "1");
mysql_select_db("123", $conn);
mysql_query("set names 'utf8'");
$sql = "select * from 123.abc";
$result = mysql_query($sql);
$res1= mysql_fetch_array ( $result, MYSQL_NUM) ;
echo json_encode ( $res1 );
mysql_close($conn);
解决方案 »
- 用socket发邮件 有个问题
- Fatal error: Uncaught SoapFault exception: [SOAP-ENV:Server]
- 急急急!!!!!authcode加密后,竟然出现部分解密不了了。。。。。。相当棘手啊~~!!!!!!!!!!
- 请教一个联合查询问题?
- Zend Studio 7.1.1中文乱码问题
- 救命啊,php的cookie
- 我要从数据库里读出数据,然后打印报表,应该怎么做呢?
- 关于MYSQL FETCH ARRAY的
- 各位高手帮忙!
- 谁来帮我一把~~~~~~~~~~~~~~~~~~~~~~!!!!!!!!!!!!!
- 能不能单独设置一个方法处理类里面的所有制异常/错误
- php怎么获取java对象
在 json_encode 之前依然是汉字