MySQL bug ?

Dear Sir/Madam,

Attached please find two files names 'test.sql' and 'mysql.log'.

 

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:

_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?

 

Best Regards,

X.L Yeung

 

 

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/bugs?unsub=gcdmb-bugs@xxxxxxxxxxx