关于MySQL UTF8编码的问题

Question

第一次用UTF8编码，在windows上没有问题，可是在linux平台上，已经将所有的编码指定为UTF8 如下：+--------------------------+----------------------------------------+
| Variable_name            | Value                                  |
+--------------------------+----------------------------------------+
| character_set_client     | utf8                                   |
| character_set_connection | utf8                                   |
| character_set_database   | utf8                                   |
| character_set_results    | utf8                                   |
| character_set_server     | utf8                                   |
| character_set_system     | utf8                                   |
| character_sets_dir       | /usr/local/mysql/share/mysql/charsets/ |
+--------------------------+----------------------------------------+
+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_general_ci |
| collation_server     | utf8_general_ci |
+----------------------+-----------------+
奇怪的是创建的表 字段类型为 varchar(10) 只能存储10 字节 而不是10个字符。提交数据 '000的000011' 存储的是 '000的0000'   而不是 '000的000011'数据库为MySQL 4.1.22  在 redhat linux 9 和 slackware linux 10.1测试均是上述情况请达人指点！！ 谢谢！！

Answer 1

问题已经解决。用黎叔的话说，大意了！大意了！