Mysql字符集设置详解
来源:互联网 发布:linux查看mysql密码 编辑:程序博客网 时间:2024/05/22 03:38
1、字符集(Character set)
2、排序比较方式(Collation)。
通过命令:show character set 和 show collation可以分别查看Mysql支持的字符集和排序方式。
mysql> show character set;
mysql> show collation;
Mysql对于字符集的支持细化到四个层次:
1、服务器(server);
2、数据库(database);
3、数据表(table)(字段column);
4、连接(connection);
1.MySQL默认字符集
2.查看默认字符集(默认情况下,Mysql的字符集是latin1(ISO_8859_1)
+--------------------------+---------------------------------+
|Variable_name
+--------------------------+---------------------------------+
|character_set_client
| character_set_connection |latin1
| character_set_database
| character_set_filesystem |binary
|character_set_results
|character_set_server
|character_set_system
|character_sets_dir
+--------------------------+---------------------------------+
mysql> SHOW VARIABLES LIKE 'collation_%';
+----------------------+-----------------+
|Variable_name
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database
|collation_server
+----------------------+-----------------+
3.修改默认字符集
(1) 最简单的修改方法,就是修改mysql的my.ini文件中的字符集键值,如 :
+--------------------------+---------------------------------+
|Variable_name
+--------------------------+---------------------------------+
|character_set_client
| character_set_connection |utf8
| character_set_database
| character_set_filesystem |binary
|character_set_results
|character_set_server
|character_set_system
|character_sets_dir