[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=utf8character_set_results 这个为什么不能单独设置成gbk?
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=utf8character_set_results 这个为什么不能单独设置成gbk?
要不将来你项目拿到别人服务器上怎么办?在连接字符串中设定下字符集就OK,平时查询的话直接用mysql工具。。比如,sqlyog 就没那么多问题了。
有两处(分别是Client和Server模式下)关于Character_Set设置,确认都改成你需要的之后,不但服务要重启,以前建立的数据库都可能需要重建