Mysql UTF8 ½â¾öÂÒÂë

1£¬ÉèÖÃmysqlĬÈϱàÂë
Ê×ÏȲéѯһÏÂshow variables like 'character%'; 
È·¶¨ËùÓеÄcharacter¶¼ÉèÖóÉutf-8  
²Î¿¼ http://www.diybl.com/course/7_databases/mysql/myxl/20081127/152726.html
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/ |
+--------------------------+----------------------------+
2£¬
a) ÉèÖÃwebÈÝÆ÷µÄ±àÂë¸ñʽ¡£ÎªÄãµÄservletµÄdoGet»òdoPost·½·¨¿ªÊ¼´¦¼ÓÈëÈçÏ´úÂ룺
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
b) Ϊÿ¸öjspÒ³ÃæÖ¸¶¨Æä±àÂë¸ñʽ¡£<%@ page pageEncoding="utf-8"%>
c) ÔÚÁ¬½ÓÊý¾Ý¿âÓõÄURLºó¼ÓÈ룺useUnicode=true;characterEncoding=utf-8¡¡È磺
¡¡¡¡                      url="jdbc:mysql:///db1?useUnicode=true&characterEncoding=utf-8"£¬
Èç¹ûÊÇxmlÎļþÖР    url="jdbc:mysql:///db1?useUnicode=true&amp;characterEncoding=utf-8"£¬
3, 
Èç¹û»¹³öÏÖÂÒÂ룬ÔòÓпÉÄÜÊÇ ±íÖеÄ×ֶΠµÄ±àÂë²»ÊÇutf-8;
Èç¹û³öÏÖÂÒÂëµÄ±íÊÇ book
mysql> show create table book;
+--------------------------+----------------------------+ 
 | Table | Create Table|
+--------------------------+----------------------------+
|book | create table 'book'(
     'id'  int(10) unsigned NOT NULL AUTO_INCREMENT,
     'bookname'  varchar(45)  CHARACTER SET latin1 NOT NULL,
     'source'  varc