Mysql under Mac does not support Chinese and the configuration file does not have a my-default.cnf file
ringa_lee2017-05-18 10:52:03
0
2
722
1. My mysql does not support Chinese. I am preparing to change the encoding according to the online method, but I cannot find the my-default.cnf file of mysql. 2. What should I do now? Let mysql support Chinese?
MySQL 5.7.18 now has no default file. Create my.cnf yourself. Should it support Chinese? My CentOS 7 Minimal version supports it. When you say it is not supported, do you mean that you directly check whether it is supported on the MAC command line (or terminal?)? Try SET character_set_client = utf8 first (php is $mysqli->set_charset('gbk'); or utf-8). If it’s still the same, then I guess the system doesn’t support it? Try using other tools, such as phpmyadmin (requires php), Navicat, SQLyog, etc.
The problem has been solved http://www.jianshu.com/p/628b...
MySQL 5.7.18 now has no default file. Create my.cnf yourself.
Should it support Chinese? My CentOS 7 Minimal version supports it.
When you say it is not supported, do you mean that you directly check whether it is supported on the MAC command line (or terminal?)?
Try SET character_set_client = utf8 first (php is $mysqli->set_charset('gbk'); or utf-8).
If it’s still the same, then I guess the system doesn’t support it? Try using other tools, such as phpmyadmin (requires php), Navicat, SQLyog, etc.