MySQL編碼問題

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

服務器租用/服務器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質保障！--億恩科技[ENKJ.COM]