你查一查那边数据库的字符集是什么字符集,而你用JSP写进去的时候又是用什么字符集,例如:
mysql> show variables like "%char%";
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | gbk |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
+--------------------------+----------------------------------------+
8 rows in set (0.16 sec)
mysql> show variables like "%char%";
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | gbk |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
+--------------------------+----------------------------------------+
8 rows in set (0.16 sec)
解决方案 »
- 为什么这样 (版本5.0.22语法错误,4.1.12顺利通过)
- 请教如何取出 GROUP BY 之后每组前N条数据
- MYSQL多表查询,请教。。
- 不明白INT(5)中的5是什么意思
- MySQL连接池设置过大出现的问题,怎么解决????
- select u_name,u_id from (select * from user_info where U_name='bbb') where U_pass='aaa' 不对吗?
- 关于net start mysql 与mysql-nt-max --install 的关系
- 请问mysql的
- 求助 mysql日志中的二进制字符串还原
- 【求助】数据库,一张表里面多对多的数据统计问题
- 急问:mysql_real_connect连接出错(bad handshake),请高手帮忙
- linux下 mysql不能 启动??
Variable_name Value
character_set latin1
character_sets latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
convert_character_set