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());