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?