- 查看数据库相关字符集设置:
SHOW VARIABLES LIKE 'char%';
SHOW VARIABLES LIKE 'collation%';
2. 修改编码:
SET variable_name=value /* SET character_set_connection=utf8; */
3:显示创建数据库信息:
SHOW CREATE DATABASE database_name
4 . 修改数据库字符集编码:
ALTER DATABASE database_name CHARACTER SET charset_name COLLATE collation_name
5. 创建数据库同时指定字符集编码:
CREATE DATABASE database_name CHARACTER SET charset_name COLLATE collation_name
6. 显示创建表信息:
SHOW CREATE TABLE table_name
7.修改表字符集信息:
ALTER TABLE table_name CONVERT TO CHARACTER SET charset_name COLLATE collation_name
8.创建表同时指定字符集编码:
CREATE TABLE table_name (column_list) CHARACTER SET charset_name COLLATE collation_name
9.显示表格列信息:
SHOW FULL COLUMNS IN table_name
10.修改表格中列的字符集编码信息:
ALTER TABLE table_name MODIFY col_name data_type CHARACTER SET charset_name COLLATE collation_name