晕了，繁体字“陳”在入库时乱码

Question

将你的字符集设置为gbk或utf-8,如果设置好的话就应该不会出现这样的问题。
mysql> show variables like "%char%";
+--------------------------+---------------------------------------------+
| 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:\MySQL\mysql-5.0.21-win32\share\charsets\ |
+--------------------------+---------------------------------------------+
8 rows in set (0.00 sec)
mysql> show variables like "%char%";
+--------------------------+--------------------------------------------------+
| Variable_name            | Value
                           |
+--------------------------+--------------------------------------------------+
| character_set_client     | gbk
                           |
| character_set_connection | gbk
                           |
| character_set_database   | gbk
                           |
| character_set_filesystem | binary
                           |
| character_set_results    | gbk
                           |
| character_set_server     | gbk
                           | 
| character_set_system     | utf8
                           |
| character_sets_dir       |C:\Program Files\MySQL\MySQL Server 5.0share\charsets\ |
+--------------------------+-------------------------------------------------------+

Answer 1

请问怎么样才能全部设置成gbk编码啊

Answer 2

我在一个JSP页面提取一个数据库表的内容时，出现乱码，我用show variables like 'character%';时就像你第二个show variables like '%char%';都是gbk，数据库连接时编码也是gbk,提取中文内容时还是乱码？？