查看MySQL当前编码情况：mysql> show variables like "%character%"; +--------------------------+----------------------------+ | 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 | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+修改为utf8编码：修改/etc/my.cnf 在[client]下增加default-character-set=utf8 在[mysqld]下增加character_set_server=utf8重新查看编码情况：mysql> show variables like "character%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+如此修改后，JDBC访问不会出现乱码。注意JSP页面编码也要写成UTF-8.Concurrent Request:Inactive phase,No Manager statusMySQL 5.5 的COMPRESSED INNODB 表相关资讯 mysql编码
- MySQL设置utf8mb4编码 （07/16/2014 09:55:08）
- mysql编码的查看 （09/28/2007 09:47:51）
| - MySQL强制编码导出、导入数据 （01/14/2013 14:01:23）
|
本文评论 查看全部评论 （0）
易网时代-编程资源站