MySQL编码问题

2014-11-24 18:47:35 · 作者: · 浏览: 0

查看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.