今天往mysql数据库中插入中文数据出现了乱码问题,使用
mysql> show variables like '%char%';显示如下:
+--------------------------+--------------------------------------------------
-----+
| Variable_name | Value
|
+--------------------------+--------------------------------------------------
-----+
| character_set_client | latin1
|
| character_set_connection | latin1
|
| character_set_database | latin1
|
| character_set_filesystem | binary
|
| character_set_results | latin1
|
| character_set_server | latin1
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.0\share\cha
ets\ |
+--------------------------+--------------------------------------------------
于是在mysql安装目录下打开my.ini文件找到default-character-set=latin1,将其修改为:default-character-set=utf8,重启,
执行mysql> show variables like '%char%';
mysql> show variables like '%char%';
+--------------------------+-------------------
-----+
| Variable_name | Value
|
+--------------------------+-------------------
-----+
| character_set_client | utf8
|
| character_set_connection | utf8
|
| character_set_database | latin1
|
| character_set_filesystem | binary
|
| character_set_results | utf8
|
| character_set_server | latin1
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\M
ets\ |
+--------------------------+-------------------
character_set_database | latin1 和 character_set_server | latin1
始终没有修改过来,乱码问题依然存在,后来尝试在数据库连接中加入?useUnicode=true&characterEncoding=UTF-8,暂时解决了问题,但是character_set_database 和 character_set_server 到哪里去修改呢?
mysql> show variables like '%char%';显示如下:
+--------------------------+--------------------------------------------------
-----+
| Variable_name | Value
|
+--------------------------+--------------------------------------------------
-----+
| character_set_client | latin1
|
| character_set_connection | latin1
|
| character_set_database | latin1
|
| character_set_filesystem | binary
|
| character_set_results | latin1
|
| character_set_server | latin1
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.0\share\cha
ets\ |
+--------------------------+--------------------------------------------------
于是在mysql安装目录下打开my.ini文件找到default-character-set=latin1,将其修改为:default-character-set=utf8,重启,
执行mysql> show variables like '%char%';
mysql> show variables like '%char%';
+--------------------------+-------------------
-----+
| Variable_name | Value
|
+--------------------------+-------------------
-----+
| character_set_client | utf8
|
| character_set_connection | utf8
|
| character_set_database | latin1
|
| character_set_filesystem | binary
|
| character_set_results | utf8
|
| character_set_server | latin1
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\M
ets\ |
+--------------------------+-------------------
character_set_database | latin1 和 character_set_server | latin1
始终没有修改过来,乱码问题依然存在,后来尝试在数据库连接中加入?useUnicode=true&characterEncoding=UTF-8,暂时解决了问题,但是character_set_database 和 character_set_server 到哪里去修改呢?
解决方案 »
- join表的索引
- 如何将一个数据库的某个表的某几个字段,导入到另一个数据库的某个表的某几个字段里
- mysql自增长数据怎么导入导出
- 目前mysql最稳定的是哪个版本呀?另外,各个版本的兼容性如何?
- MySQL的初级问题
- mysql version 4.0.13-nt,能不能用一个sql语句实现这样的select
- 请教Java连接mysql数据库的问题,谢谢!
- 亲问,mysql问题!
- 请教个位大虾一个数据库的基础知识!!!!!!!!!!100分!!!!
- ASP如何得到MySQL选出来的记录总数?
- postgresql备份
- Mysql中是否有判断两个日期间隔多少工作日(排除周六周日和节日)的函数?
character_set_server 是你 my.ini 中的 [mysqld] 节中的 default-character-set (注意是mysqld 中而不是 mysql 下的那个)
MySQL 中文显示乱码