1.查看MySQL能够支持的多种字符集:
show character set;
查看MySQL能够支持的字符集的校对规则:
show collation;
show collation like 'utf8%';
2.查看当前字符集及校对
show variables like 'character_set%';
show variables like 'collation_%';
3.字符集系统变量介绍:
character_set_server:默认的内部操作字符集
character_set_client:客户端来源数据使用的字符集
character_set_connection:连接层字符集
character_set_results:查询结果字符集
character_set_database:当前选中数据库的默认字符集
character_set_system:系统元数据(字段名等)字符集
字符集转换过程:
MySQL Server收到请求时将请求数据从character_set_client转换为character_set_connection
进行内部操作前将请求数据从character_set_connection转换为内部操作字符集
4.修改连接字符集:
set names utf8;
等价于:
set character_set_client = utf8;
set character_set_results = utf8;
set character_set_connection = utf8;
5.修改my.cnf的服务器字符集和客户端字符集(5.1)
[client]
default-character-set=UTF8
[mysqld]
default-character-set=UTF8
[mysql]
default-character-set=UTF8
6.修改my.cnf的服务器字符集和客户端字符集(5.5以上)
[client]
default-character-set=UTF8
[mysqld]
character-set-server=utf8
[mysql]
default-character-set=UTF8
show character set;
查看MySQL能够支持的字符集的校对规则:
show collation;
show collation like 'utf8%';
2.查看当前字符集及校对
show variables like 'character_set%';
show variables like 'collation_%';
3.字符集系统变量介绍:
character_set_server:默认的内部操作字符集
character_set_client:客户端来源数据使用的字符集
character_set_connection:连接层字符集
character_set_results:查询结果字符集
character_set_database:当前选中数据库的默认字符集
character_set_system:系统元数据(字段名等)字符集
字符集转换过程:
MySQL Server收到请求时将请求数据从character_set_client转换为character_set_connection
进行内部操作前将请求数据从character_set_connection转换为内部操作字符集
4.修改连接字符集:
set names utf8;
等价于:
set character_set_client = utf8;
set character_set_results = utf8;
set character_set_connection = utf8;
5.修改my.cnf的服务器字符集和客户端字符集(5.1)
[client]
default-character-set=UTF8
[mysqld]
default-character-set=UTF8
[mysql]
default-character-set=UTF8
6.修改my.cnf的服务器字符集和客户端字符集(5.5以上)
[client]
default-character-set=UTF8
[mysqld]
character-set-server=utf8
[mysql]
default-character-set=UTF8