在sql语句上加了如下设置,
SET character_set_client = utf8;
SET character_set_connection = utf8;
SET character_set_database = utf8;
SET character_set_results = utf8;
SET character_set_server = utf8;
SET collation_connection = utf8_general_ci;
SET collation_database = utf8_general_ci;
SET collation_server = utf8_general_ci;当查询时,所有的中文都变为了???
在my.ini中加入了
mysqld]
default-character-set=utf8
# mysql 安装目录
basedir=D:/Java/mysql
# 数据库路径
datadir=D:/Java/mysql/data
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
还是一样,请问怎么回事?
SET character_set_client = utf8;
SET character_set_connection = utf8;
SET character_set_database = utf8;
SET character_set_results = utf8;
SET character_set_server = utf8;
SET collation_connection = utf8_general_ci;
SET collation_database = utf8_general_ci;
SET collation_server = utf8_general_ci;当查询时,所有的中文都变为了???
在my.ini中加入了
mysqld]
default-character-set=utf8
# mysql 安装目录
basedir=D:/Java/mysql
# 数据库路径
datadir=D:/Java/mysql/data
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
还是一样,请问怎么回事?
2.在DOS界面下:
CREATE DATABASE $dbname DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
就说道这,试一试吧!