登录  /  注册
mysql配置没问题,但不显示中文;
吴勇文
吴勇文 2018-08-27 23:55:00
[MySQL讨论组]

mysql> show variables like "%colla%";
+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_general_ci |
| collation_server     | utf8_general_ci |
+----------------------+-----------------+

mysql>  show variables like "%char%";
+--------------------------+-----------------------------------------------+
| Variable_name            | Value                                         |
+--------------------------+-----------------------------------------------+
| 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       | C:\phpStudy\PHPTutorial\MySQL\share\charsets\ |
+--------------------------+-----------------------------------------------+

mysql> create table emp3(
    ->   `id` int(11) NOT NULL AUTO_INCREMENT,
    ->   `username` varchar(50) NOT NULL,
    ->   `balance` float NOT NULL,
    ->   `province` varchar(20) NOT NULL,
    ->   `age` tinyint(3) unsigned NOT NULL,
    ->   `sex` tinyint(4) NOT NULL,
    ->   PRIMARY KEY (`id`)
    -> ) ENGINE=InnoDB CHARSET=utf8;
Query OK, 0 rows affected (0.03 sec)

QQ图片20180827235422.png

吴勇文
吴勇文

加油!努力!奋斗!

热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
关于我们 免责申明 意见反馈 讲师合作 广告合作 最新更新
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送
PHP中文网APP
随时随地碎片化学习
PHP中文网抖音号
发现有趣的

Copyright 2014-2024 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号