插入MYSQL中文乱码

1.建表过程如下

create database  test default character set utf8 collate utf8_general_ci

use test;

create table devicedata
(
 ID int auto_increment PRIMARY key ,
 TimeStamp datetime,
 Device_Name varchar(100),
 Tag_Name varchar(100),
 Value varchar(50)
)

2.找到MYSQL的配置文件做如下修改

  [client]

port=3306

[mysql]

default-character-set=gbk

[mysqld]

default-character-set=gbk

重启MYSQL服务

CMD  net stop mysql

         net start mysql