1.数据库编码是UTF-8
2.客户端编码是GBK;
如何插入中文
例子:
CREATE DATABASE mydb;
USE mydb5;
CREATE TABLE news
(
)default charset=utf8;
set names gb2312;
INSERT INTO news VALUES(null, '新闻1', '111111', now());
INSERT INTO news VALUES(null, '新闻2', '222222', now());
INSERT INTO news VALUES(null, '新闻3', '333333', now());
INSERT INTO news VALUES(null, '新闻4', '444444', now());
INSERT INTO news VALUES(null, '新闻5', '555555', now());