MySQL編碼問(wèn)題

查看MySQL當(dāng)前編碼情況：

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訪問(wèn)不會(huì)出現(xiàn)亂碼。

注意JSP頁(yè)面編碼也要寫(xiě)成UTF-8.

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]