mysql 数据库编码是UTF-8 如何解决乱码问题

1.数据库编码是UTF-8

2.客户端编码是GBK;

如何插入中文

例子:

CREATE DATABASE mydb;

USE mydb5;

CREATE TABLE news
(
      news_id int not null auto_increment,
      news_title varchar(100) not null,
      news_contents text not null,
      news_date datetime not null,
      primary key(news_id)
)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());