找到[client]在下面加入
default-character-set=utf8
找到 [mysqld_safe]在下面加入
default-character-set=utf8
找到[mysqld]在下面加入
character-set-server=utf8
collation-server=utf8_general_ci
找到[mysql]在下面加入default-character-set=utf8
上述红色的是5.5以后必须按照这个修改,不然重启mysql后会出现start:Job failed to start
然后重启 /ect/init.d/mysql restart
2.查看现在mysql的编码
进入mysql命令:sudo mysql -u root -p
检查mysql字符集命令:show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
3.注意创建表的时候要使用utf8格式
create table customers
(
cust_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
cust_name CHAR(50) NOT NULL,
cust_sex CHAR(1) NOT NULL DEFAULT 0,
cust_address CHAR(50) NULL,
cust_contact CHAR(50) NULL
8)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
4. ok