1,创建数据库时
CREATE DATABASE demo_db **DEFAULT CHARACTER SET utf8COLLATE utf8_general_ci;**
2,建表的时候
CREATE TABLE `database_user` (
`ID` varchar(40) NOT NULL default '',
`UserID` varchar(40) NOT NULL default '',
) ENGINE=InnoDB **DEFAULT CHARSET=utf8;**看默认的编码格式:
mysql> show variables like “%char%”;
4,设置不是utf8的。
SET character_set_client=’utf8’;
SET character_set_connection=’utf8’;
SET character_set_results=’utf8’;
5,vim /etc/my.cnf 追加default-character-set=utf8
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
**default-character-set=utf8**
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
6,重启mysql
service mysqld restart
“`