MySQL INSERT bug?

SQL server version:      4.1.17
Character Set:           gbk

Table structure:
Field      Type         Collation
_rec       int(10) unsigned
_timestamp timestamp
PARENT     varchar(8)   gbk_chinese_ci
TYPE       char(1)      gbk_chinese_ci
CHILD      varchar(8)   gbk_chinese_ci
QTY        double
ECNNO      varchar(5)   gbk_chinese_ci
ALTPART    char(1)      gbk_chinese_ci
EFF_DTE    date


The problem is all single bytes characters are treated as double
bytes characters when use "INSERT INTO" command.
INSERT INTO bi VALUES (NULL,NULL,'41-005422SJL-01','P','01-0010600C-00 ',1.0000,'          ',' ','20040326');
INSERT INTO bi VALUES (NULL,NULL,'一二三四五六七八','P','01-0214200M-08 ',1.0000,'          ',' ','20040326');
INSERT INTO bi VALUES (NULL,NULL,'41-0三四五六七八','P','01-0214200M-08 ',1.0000,'          ',' ','20040326');

The results(SELECT * FROM bi):
_rec _timestamp          PARENT          TYPE      CHILD      QTY ECNNO ALTPART EFF_DTE
1    2004-11-11 09:00:26 41-00542         P        01-00106    1                2004-03-26
2    2004-11-11 09:00:26 一二三四五六七八  P        01-02142    1                2004-03-26
3    2004-11-11 09:00:26 41-0三四五六     P        01-02142     1                2004-03-26


Is it a bug of MySQL or I just make some mistake?

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]