一、避免创建数据库及表出现中文乱码和查看编码方法
1、创建
创建数据库的时候:
CREATE DATABASE `test_db`
CHARACTER SET 'utf8'
COLLATE 'utf8_bin';
建表的时候
CREATE TABLE `database_user` (
`username` varchar(40) NOT NULL default '',
`password` varchar(40) NOT NULL default '',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2、查看
1、查看默认的编码格式:
mysql> show variables like "%char%";
+--------------------------+---------------+
| Variable_name | Value |
+--------------------------+---------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | utf8 |
| character_set_system | utf8 |
+--------------------------+-------------+
2、查看test_db数据库的编码格式:
mysql> show create database test_db;
+------------+------------------------------------------------------------------------------------------------+
| Database | Create Database |
+------------+------------------------------------------------------------------------------------------------+
| test | CREATE DATABASE `test_db` /*!40100 DEFAULT CHARACTER SET gbk */ |
+------------+------------------------------------------------------------------------------------------------+
3、查看数据表的编码格式:
mysql> show create table table_name;
3、修改字符集
执行SET NAMES utf8的效果等同于同时设定如下:
SET character_set_client='utf8';
SET character_set_connection='utf8';
SET character_set_results='utf8';