文章目录[隐藏]
语句 show variables like ‘char%’;
为什么phpmyadmin 和 cls下结果不同
phpmyadmin
Variable_name Valuecharacter_set_client utf8character_set_connection utf8character_set_database utf8character_set_filesystem binarycharacter_set_results utf8character_set_server latin1character_set_system utf8character_sets_dir C:\Program Files<strong>*本文来@源gao@daima#com搞(%代@#码@网2</strong><pre>搞代gaodaima码
\MySQL\MySQL Server 5.1\share\char…
cls
mysql> show variables like 'char%';+--------------------------+---------------------------------------------------------+| Variable_name | Value |+--------------------------+---------------------------------------------------------+| character_set_client | latin1 || character_set_connection | latin1 || character_set_database | utf8 || character_set_filesystem | binary || character_set_results | latin1 || character_set_server | latin1 || character_set_system | utf8 || character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.1\share\charsets\ |+--------------------------+---------------------------------------------------------+8 rows in set (0.00 sec)
回复讨论(解决方案)
因为 phpmyadmin 在执行 show variables like ‘char%’; 前
先执行了 set names utf8
没遇到过，飘过…..
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：show variables在phpmyadmin 和 cls下结果不同？
转载请注明原文链接：show variables在phpmyadmin 和 cls下结果不同？
