在mysql 的安装目录下的my.ini文件里的默认编码有问题,将my.ini文件的这两处的默认编码
[mysql]
default-character-set=utf8 <------
[mysqld]
The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir=“C:/Program Files/MySQL/MySQL Server 5.0/”
#Path to the database root
datadir=“C:/Program Files/MySQL/MySQL Server 5.0/Data/”
The default character set that will be used when a new schema or table is
created and no character set is defined
default-character-set=utf8 <------
箭头所指的地方确保为utf8(注意不是utf-8),navicat 里的使用的是mysql字符集(注意不用再选择utf-8编码)