?????????Σ????????????

????X:\%path%MySQLMySQL Server 5.0inMySQLInstanceConfig.exe

?????????????????????????????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       | C:Program FilesMySQLMySQL Server 5.0sharecharsets |
????+--------------------------+---------------------------------------------------------+

????8 rows in set

???????????????

????1?????????utf8??????ε?Collation??????????????????utf8_general_ci???

CREATE TABLE `tablename4` (
`id` int(11) NOT NULL AUTO_INCREMENT??
`varchar1` varchar(255) DEFAULT NULL??
`varbinary1` varbinary(255) DEFAULT NULL??
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

????2?????xxx.php/jsp????????utf8???????ü???

????header('conten-type:text/html;charset=utf-8');

?????????CRUD?????????????

????mysql_query("set names utf8");

????-------------------------

????????????????????

????jdbc:mysql://???:3306/????????characterEncoding=utf8

????-------------------------

????java?е???????UTF-8;GBK;GB2312;ISO-8859-1;

???????mysql??????е????utf8;gbk;gb2312;latin1