你查一查那边数据库的字符集是什么字符集,而你用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)
解决方案 »
- 更新字段问题
- [MYSQL]----SELECT * INTO OUTFILE如何实现将导出的文件是在客户端,而不是服务器呢?
- MySql 怪异问题Parameter '?applicantOperator' must be defined
- SQL查询急求帮助!!!!!!!!!!!!
- 求解决多列名次问题
- 5.0.45-后面 的 0 表示 什么意思?
- 请问这种写入mysql数据库是采用什么技术?
- 一个关于字符编码的问题
- 在我的phpadmin中总有这句"使用链接表的额外特性尚未激活。要查出原因,请单击此处。"是什么意思呢?
- 请教高手,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