mysql插入中文乱码问题

Question

我的mysql字符集设置：
mysql> show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_general_ci |
| collation_server     | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)要通过C的API向mysql中插入数据，要插入的数据在linux终端通过默认的unicode(utf-8)正常显示，但是插入数据库后显示为乱码，再通过C Api select 后，在终端显示正常，但是从web端select，在web显示同样为乱码，这究竟是什么原因？

Answer 1

如果是乱码 尝试set names gbk or  set names utf8都试试