查看RDS实例字符集相关参数设置:
show global variables like '%char%';
查看当前会话字符集相关参数设置:
show global variables like 'coll%';
查看实例支持的字符集:
show character set;
查看实例支持的字符序:
show collation;
查看表字符集设置:
show create table table_name \G
查看数据库字符集设置:
show create database database_name \G
查看存储过程字符集设置:
show create procedure procedure_name \G 和 show procedure status \G
修改数据库的字符集:
alter database db_name default charset utf8;
创建数据库时指定字符集:
create database db_name character set utf8;
修改表字符集和字符序示例:
alter table tab_name default charset utf8 collate utf8_general_ci;
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20