Home >Database >Mysql Tutorial >mysql编码、数据表编码查看和修改总结_MySQL
mysql编码、数据表编码查看和修改总结_MySQL
- WBOYOriginal
- 2016-06-01 13:11:52976browse
1，查看自己安装的mysql的编码
2、查看Mysql支持的编码
3、查看数据库编码
4、查看数据表编码（show create table user /G;）
5、修改my.ini文件来修改编码：加上default-character-set=字符集（utf8.gbk.gb2312等）
6、命令行修改：alter database da_name default character set "charset' ；或 set names 'charset'；或alter database testdb character set utf8;
8、查看数据库服务和客户端字符集：
9、Linux系统下的修改：
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql创建用户操作_MySQLNext article：快速打开mysql的方法，简单的批处理命令_MySQL