mysql编码的查看和修改

---

1. 查看数据库支持的所有字符集

show character set;或show char set;

2. 查看系统字符集设置，包括所有的字符集设置

show variables like 'char%';

3. 查看数据表中字符集设置

show full columns from tablename; 或者 show create table tablename;

4. 查看数据库编码

show create database dnname;

---

修改(永久):

修改数据库编码

ALTER DATABASE dbname CHARACTER SET utf8;

修改表的编码:ALTER TABLE tbname CONVERT TO CHARACTER SET utf8;

---

修改(临时):

SET NAMES utf8;
SET character_set_client = utf8 ;
SET character_set_connection = utf8 ;
SET character_set_database = utf8 ;
SET character_set_results = utf8 ;
SET character_set_server = utf8 ;
SET collation_connection = utf8 ;
SET collation_database = utf8 ;
SET collation_server = utf8 ;

---

补充:

创建时指定字符集

级别 命令

1. 服务器级 在安装MySQL时可以设置服务器的默认编码格式

2. 数据库级

CREATE DATABASE db_name DEFAULT CHARACTER SET utf8;

3. 表级

CREATE TABLE `db_name`.`tb_name` ( id VARCHAR(20) NOT NULL, name VARCHAR(20)) ENGINE=InnoDB DEFAULT CHARSET=utf8;