操作系统:xp professional sp2以下操作在MySQL Command Line 进行
mysql> select version()
    -> ;
+-----------+
| version() |
+-----------+
| 5.0.18-nt |
+-----------+
1 row in set (0.02 sec)mysql> show variables like '%char%';
+--------------------------+----------------------------------------------------
-----+
| 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       | E:\Program Files\MySQL\MySQL Server 5.0\share\chars
ets\ |
+--------------------------+----------------------------------------------------
-----+
7 rows in set (0.08 sec)mysql> show variables like "%colla%";
+----------------------+-----------------+
| 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> describe shbhc;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| depart   | varchar(32) | YES  |     | NULL    |       |
| name     | varchar(40) | YES  |     | NULL    |       |
| type     | varchar(40) | YES  |     | NULL    |       |
| status   | bit(2)      | YES  |     | NULL    |       |
| datetime | datetime    | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
5 rows in set (0.21 sec)mysql> insert into shbhc values ('人事','打印纸','A4',0,NULL);
ERROR 1406 (22001): Data too long for column 'depart' at row 1