mysql版本5.0.0 从mysql调出中文用jsp显示、
jsp页面的编码格式全是utf-8之后也跟着数据库改编码 统一
mysql我百度了下、
1、从数据库设置 set names “UTF8” 不好使
2、数据库的连接地址url中,一定要后缀:?useUnicode=true&characterEncoding=gbk后面改编码gbk
之后改了JSP的编码为gbk 也不行
3、my.ini 那个我没有 自己写的好像没读进去、下面是我C:\windows\my.ini文件[mysqld]
# set basedir to installation path, e.g., c:/mysql
# 设置为MYSQL的安装目录
basedir=C:/mysql
# set datadir to location of data directory,
# e.g., c:/mysql/data
# 设置为MYSQL的数据目录
datadir=c:/mysql/data
[Client]
user=root
default-character-set = gbk不懂怎么插图、手打吧
mysql> SHOW VARIABLES LIKE “character_set_%”;
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | C:\mysql\share\charsets/ |
+--------------------------+----------------------------+
7 rows in set (0.00 sec) mysql> SHOW VARIABLES LIKE ''collation_%'';
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)
也试了试SET character_set_client = utf8; 还是不行、
jsp跟着mysql编码一直变的、
求解释
jsp页面的编码格式全是utf-8之后也跟着数据库改编码 统一
mysql我百度了下、
1、从数据库设置 set names “UTF8” 不好使
2、数据库的连接地址url中,一定要后缀:?useUnicode=true&characterEncoding=gbk后面改编码gbk
之后改了JSP的编码为gbk 也不行
3、my.ini 那个我没有 自己写的好像没读进去、下面是我C:\windows\my.ini文件[mysqld]
# set basedir to installation path, e.g., c:/mysql
# 设置为MYSQL的安装目录
basedir=C:/mysql
# set datadir to location of data directory,
# e.g., c:/mysql/data
# 设置为MYSQL的数据目录
datadir=c:/mysql/data
[Client]
user=root
default-character-set = gbk不懂怎么插图、手打吧
mysql> SHOW VARIABLES LIKE “character_set_%”;
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | C:\mysql\share\charsets/ |
+--------------------------+----------------------------+
7 rows in set (0.00 sec) mysql> SHOW VARIABLES LIKE ''collation_%'';
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)
也试了试SET character_set_client = utf8; 还是不行、
jsp跟着mysql编码一直变的、
求解释
MySQL 中文显示乱码
手打 我贴出带有中文的列吧
create table staff(
staff_ID varchar(10) not null ,
staff_Name varchar(20) not null,//这个是有中文名字项
staff_Brith datetime not null default'0000-00-00 00:00:00',
staff_IDcard varchar(18) not null,)
mysql> show full columns from t1;
+-------+-------------+----------------+------+-----+-
| Field | Type | Collation | Null | Key | default
+-------+-------------+----------------+------+-----+-
| staff_Name | varchar(20) | latin1_swedish_ci | | |
| select,insert,update,references|
+-------+-------------+----------------+------+-----+-
5 rows in set (0.00 sec)
其他那俩个在上面
+-------+-------------+----------------+------+-----+-
| Field | Type | Collation | Null | Key | default
+-------+-------------+----------------+------+-----+-
| staff_Name | varchar(20) | latin1_swedish_ci | | |
| select,insert,update,references|
+-------+-------------+----------------+------+-----+-
5 rows in set (0.00 sec) 问题在这里,你使用的是LATIN字符集,并不是支持汉字的GBK或者UTF8.