0 0

C3P0插入MYSQL出现乱码 [Java Java相关] 20

描述: 如题
详细描述: myEclipse下 java项目,以前使用JDBC可以正确插入。 现修改为C3P0插入,汉字出现乱码 。
备注: url 已添加useUnicode=true&characterEncoding=UTF8 ;MYSQL 数据库表也设置为 UTF-8 ; 插入前SQL语句打印也正常显示;
大神来提点提点 =_ =
还有可能是什么原 C3P0插入MYSQL出现乱码 [Java Java相关] 因导致插入数据乱码 。 乱码显示就一堆 ??????

问题补充:使用命令 mysql> show VARIABLES;
查询出有关字符集结果也都正常
如下
|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                                | /usr/share/mysql/charsets/                                                                                             |
| collation_connection                              | utf8_general_ci                                                                                                        |
| collation_database                                | latin1_swedish_ci                                                                                                      |
| collation_server                                  | latin1_swedish_ci                                                                                                      |
| completion_type                                   | NO_CHAIN                                                                                                               |
| concurrent_insert                                 | AUTO                                                                                                                   |
| connect_timeout                                   | 10                                                                                                                     |
2014年11月13日 11:46

2个答案 按时间排序 按投票排序

0 0

SET gb2312 COLLATE gb2312_bin
试一下  gb2312_bin 字符集,好像没有UTF-8吧

2014年11月14日 13:30
0 0

我怎么记得应该这么写?
useUnicode=yes&characterEncoding=UTF-8

2014年11月13日 12:55

相关推荐

Global site tag (gtag.js) - Google Analytics