MySQL INSERT bug?

MySQL INSERT bug?

am 13.11.2004 01:26:13 von webmaster

------=_NextPart_000_0013_01C4C95A.6FF3BA20
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0014_01C4C95A.6FFCE1E0"


------=_NextPart_001_0014_01C4C95A.6FFCE1E0
Content-Type: text/plain;
charset="gb2312"
Content-Transfer-Encoding: base64

U1FMIHNlcnZlciB2ZXJzaW9uOiAgICAgIDQuMS4xNw0KQ2hhcmFjdGVyIFNl dDogICAgICAgICAg
IGdiaw0KDQpUYWJsZSBzdHJ1Y3R1cmU6DQpGaWVsZCAgICAgIFR5cGUgICAg ICAgICBDb2xsYXRp
b24NCl9yZWMgICAgICAgaW50KDEwKSB1bnNpZ25lZA0KX3RpbWVzdGFtcCB0 aW1lc3RhbXANClBB
UkVOVCAgICAgdmFyY2hhcig4KSAgIGdia19jaGluZXNlX2NpDQpUWVBFICAg ICAgIGNoYXIoMSkg
ICAgICBnYmtfY2hpbmVzZV9jaQ0KQ0hJTEQgICAgICB2YXJjaGFyKDgpICAg Z2JrX2NoaW5lc2Vf
Y2kNClFUWSAgICAgICAgZG91YmxlDQpFQ05OTyAgICAgIHZhcmNoYXIoNSkg ICBnYmtfY2hpbmVz
ZV9jaQ0KQUxUUEFSVCAgICBjaGFyKDEpICAgICAgZ2JrX2NoaW5lc2VfY2kN CkVGRl9EVEUgICAg
ZGF0ZQ0KDQoNClRoZSBwcm9ibGVtIGlzIGFsbCBzaW5nbGUgYnl0ZXMgY2hh cmFjdGVycyBhcmUg
dHJlYXRlZCBhcyBkb3VibGUNCmJ5dGVzIGNoYXJhY3RlcnMgd2hlbiB1c2Ug IklOU0VSVCBJTlRP
IiBjb21tYW5kLg0KSU5TRVJUIElOVE8gYmkgVkFMVUVTIChOVUxMLE5VTEws JzQxLTAwNTQyMlNK
TC0wMScsJ1AnLCcwMS0wMDEwNjAwQy0wMCAnLDEuMDAwMCwnICAgICAgICAg ICcsJyAnLCcyMDA0
MDMyNicpOw0KSU5TRVJUIElOVE8gYmkgVkFMVUVTIChOVUxMLE5VTEwsJ9K7 tv7I/cvEzuXB+cbf
sMsnLCdQJywnMDEtMDIxNDIwME0tMDggJywxLjAwMDAsJyAgICAgICAgICAn LCcgJywnMjAwNDAz
MjYnKTsNCklOU0VSVCBJTlRPIGJpIFZBTFVFUyAoTlVMTCxOVUxMLCc0MS0w yP3LxM7lwfnG37DL
JywnUCcsJzAxLTAyMTQyMDBNLTA4ICcsMS4wMDAwLCcgICAgICAgICAgJywn ICcsJzIwMDQwMzI2
Jyk7DQoNClRoZSByZXN1bHRzKFNFTEVDVCAqIEZST00gYmkpOg0KX3JlYyBf dGltZXN0YW1wICAg
ICAgICAgIFBBUkVOVCAgICAgICAgICBUWVBFICAgICAgQ0hJTEQgICAgICBR VFkgRUNOTk8gQUxU
UEFSVCBFRkZfRFRFDQoxICAgIDIwMDQtMTEtMTEgMDk6MDA6MjYgNDEtMDA1 NDIgICAgICAgICBQ
ICAgICAgICAwMS0wMDEwNiAgICAxICAgICAgICAgICAgICAgIDIwMDQtMDMt MjYNCjIgICAgMjAw
NC0xMS0xMSAwOTowMDoyNiDSu7b+yP3LxM7lwfnG37DLICBQICAgICAgICAw MS0wMjE0MiAgICAx
ICAgICAgICAgICAgICAgIDIwMDQtMDMtMjYNCjMgICAgMjAwNC0xMS0xMSAw OTowMDoyNiA0MS0w
yP3LxM7lwfkgICAgIFAgICAgICAgIDAxLTAyMTQyICAgICAxICAgICAgICAg ICAgICAgIDIwMDQt
MDMtMjYNCg0KDQpJcyBpdCBhIGJ1ZyBvZiBNeVNRTCBvciBJIGp1c3QgbWFr ZSBzb21lIG1pc3Rh
a2U/DQo=

------=_NextPart_001_0014_01C4C95A.6FFCE1E0
Content-Type: text/html;
charset="gb2312"
Content-Transfer-Encoding: base64

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBU cmFuc2l0aW9uYWwv
L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgaHR0cC1lcXVpdj1Db250ZW50 LVR5cGUgY29udGVu
dD0idGV4dC9odG1sOyBjaGFyc2V0PWdiMjMxMiI+DQo8TUVUQSBjb250ZW50 PSJNU0hUTUwgNi4w
MC4yODAwLjE0NzYiIG5hbWU9R0VORVJBVE9SPg0KPFNUWUxFPjwvU1RZTEU+ DQo8L0hFQUQ+DQo8
Qk9EWSBiZ0NvbG9yPSNmZmZmZmY+DQo8RElWPjxGT05UIHNpemU9Mj4NCjxE SVY+PEZPTlQgc2l6
ZT0yPlNRTCBzZXJ2ZXIgdmVyc2lvbjombmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsgDQo0
LjEuMTc8L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIHNpemU9Mj5DaGFyYWN0 ZXIgDQpTZXQ6Jm5i
c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7
IA0KZ2JrPC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBzaXplPTI+PC9GT05U PiZuYnNwOzwvRElW
Pg0KPERJVj48Rk9OVCBzaXplPTI+VGFibGUgc3RydWN0dXJlOjwvRk9OVD48 L0RJVj4NCjxESVY+
PEZPTlQgc2l6ZT0yPkZpZWxkJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7IA0KVHlwZSZu
YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyBDb2xsYXRpb248
L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIHNpemU9Mj5fcmVjJm5ic3A7Jm5i c3A7Jm5ic3A7Jm5i
c3A7Jm5ic3A7Jm5ic3A7IGludCgxMCkgDQp1bnNpZ25lZDxCUj5fdGltZXN0 YW1wJm5ic3A7dGlt
ZXN0YW1wPEJSPlBBUkVOVCZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyANCnZh cmNoYXIoOCkmbmJz
cDsmbmJzcDsgZ2JrX2NoaW5lc2VfY2k8L0ZPTlQ+PC9ESVY+DQo8RElWPjxG T05UIHNpemU9Mj5U
WVBFJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KJm5ic3A7Y2hh cigxKSZuYnNwOyZu
YnNwOyZuYnNwOyZuYnNwOyANCiZuYnNwO2dia19jaGluZXNlX2NpPEJSPkNI SUxEJm5ic3A7Jm5i
c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7dmFyY2hhcig4KSZuYnNwOyZu YnNwOyZuYnNwO2di
a19jaGluZXNlX2NpPEJSPlFUWSZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyAN
CiZuYnNwO2RvdWJsZTwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgc2l6ZT0y PkVDTk5PJm5ic3A7
Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KJm5ic3A7dmFyY2hhcig1KSZuYnNwOyZu YnNwOyZuYnNwO2di
a19jaGluZXNlX2NpPC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBzaXplPTI+ QUxUUEFSVCZuYnNw
OyZuYnNwOyANCiZuYnNwO2NoYXIoMSkmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsgDQpn
YmtfY2hpbmVzZV9jaTxCUj5FRkZfRFRFJm5ic3A7Jm5ic3A7ICZuYnNwO2Rh dGU8QlI+PC9ESVY+
PC9GT05UPg0KPERJVj48Rk9OVCBzaXplPTI+PC9GT05UPiZuYnNwOzwvRElW Pg0KPERJVj48Rk9O
VCBzaXplPTI+VGhlIHByb2JsZW0gaXMgPC9GT05UPjxTVFJPTkc+PEZPTlQg Y29sb3I9I2ZmMDAw
MCANCnNpemU9Mz48VT5hbGwgc2luZ2xlIGJ5dGVzIGNoYXJhY3RlcnMgYXJl IHRyZWF0ZWQgYXMg
DQpkb3VibGU8L1U+PC9GT05UPjwvU1RST05HPjwvRElWPg0KPERJVj48Rk9O VCBzaXplPTI+PFNU
Uk9ORz48Rk9OVCBjb2xvcj0jZmYwMDAwIHNpemU9Mz48VT5ieXRlcyBjaGFy YWN0ZXJzIHdoZW4g
DQp1c2UgIklOU0VSVCBJTlRPIiBjb21tYW5kPC9VPjwvRk9OVD48L1NUUk9O Rz4uPC9GT05UPjwv
RElWPg0KPERJVj48Rk9OVCBzaXplPTI+SU5TRVJUIElOVE8gYmkgVkFMVUVT IA0KKE5VTEwsTlVM
TCwnNDEtMDA1NDIyU0pMLTAxJywnUCcsJzAxLTAwMTA2MDBDLTAwIA0KJywx LjAwMDAsJyZuYnNw
OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyAnLCcgDQon
LCcyMDA0MDMyNicpOzxCUj5JTlNFUlQgSU5UTyBiaSBWQUxVRVMgDQooTlVM TCxOVUxMLCfSu7b+
yP3LxM7lwfnG37DLJywnUCcsJzAxLTAyMTQyMDBNLTA4IA0KJywxLjAwMDAs JyZuYnNwOyZuYnNw
OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyAn LCcgDQonLCcyMDA0
MDMyNicpOzxCUj5JTlNFUlQgSU5UTyBiaSBWQUxVRVMgDQooTlVMTCxOVUxM LCc0MS0wyP3LxM7l
wfnG37DLJywnUCcsJzAxLTAyMTQyMDBNLTA4IA0KJywxLjAwMDAsJyZuYnNw OyZuYnNwOyZuYnNw
OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyAnLCcgDQon LCcyMDA0MDMyNicp
OzxCUj48L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIHNpemU9Mj5UaGUgcmVz dWx0cyhTRUxFQ1Qg
KiBGUk9NIGJpKTo8L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIA0Kc2l6ZT0y Pl9yZWMmbmJzcDtf
dGltZXN0YW1wJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7
IA0KJm5ic3A7UEFSRU5UJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7
Jm5ic3A7IA0KJm5ic3A7VFlQRSZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyBDSElMRCZu
YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyANClFUWSZuYnNwO0VDTk5P Jm5ic3A7QUxUUEFS
VCZuYnNwO0VGRl9EVEU8QlI+MSZuYnNwOyZuYnNwOyZuYnNwOyAyMDA0LTEx LTExIA0KMDk6MDA6
MjYmbmJzcDs0MS0wMDU0MiZuYnNwOyZuYnNwOyZuYnNwOyAmbmJzcDsmbmJz cDsmbmJzcDsgDQom
bmJzcDtQJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7ICZu YnNwOzAxLTAwMTA2
Jm5ic3A7Jm5ic3A7IA0KJm5ic3A7MSZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNw
OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyANCiZuYnNw
OzIwMDQtMDMtMjY8QlI+MiZuYnNwOyZuYnNwOyZuYnNwOyAyMDA0LTExLTEx IDA5OjAwOjI2Jm5i
c3A70ru2/sj9y8TO5cH5xt+wyyZuYnNwOyANClAmbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsmbmJz
cDsmbmJzcDsgJm5ic3A7MDEtMDIxNDImbmJzcDsmbmJzcDsgDQombmJzcDsx Jm5ic3A7Jm5ic3A7
Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5i
c3A7IA0KJm5ic3A7Jm5ic3A7Jm5ic3A7MjAwNC0wMy0yNjxCUj4zJm5ic3A7 Jm5ic3A7Jm5ic3A7
IDIwMDQtMTEtMTEgDQowOTowMDoyNiZuYnNwOzQxLTDI/cvEzuXB+SZuYnNw OyAmbmJzcDsmbmJz
cDsgDQpQJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7IDAxLTAyMTQy
Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KJm5ic3A7MSZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNw
OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyAN CiZuYnNwOyZuYnNw
OyZuYnNwOzIwMDQtMDMtMjY8QlI+PC9GT05UPjwvRElWPg0KPERJVj48Rk9O VCBzaXplPTI+PC9G
T05UPiZuYnNwOzwvRElWPg0KPERJVj48Rk9OVCBzaXplPTI+SXMgaXQgYSBi dWcgb2YgTXlTUUwg
b3IgSSBqdXN0IG1ha2Ugc29tZSBtaXN0YWtlPzwvRk9OVD48L0RJVj4NCjxE SVY+Jm5ic3A7PC9E
SVY+PC9GT05UPjwvRElWPjwvQk9EWT48L0hUTUw+DQo=

------=_NextPart_001_0014_01C4C95A.6FFCE1E0--


------=_NextPart_000_0013_01C4C95A.6FF3BA20
Content-Type: text/plain; charset=us-ascii

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
------=_NextPart_000_0013_01C4C95A.6FF3BA20--

Re: MySQL INSERT bug?

am 13.11.2004 03:06:11 von Ed Korthof

On Sat, Nov 13, 2004 at 08:26:13AM +0800, webmaster@casildot.com wrote:
> 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');
CHILD. The strings above are longer.
> 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');

Your table definition allows for exactly 8 characters for PARENT and
CHILD. The strings above are longer.

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

41-00542 01-00106

01234567 01234567

This is the first 8 characters of the string you provided. It looks
like MySQL is truncating at character boundaries respecting the encoding
in use and the column definitions.


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

It looks like you want wider columns.

thanks --

Ed
--
+=-=+=-=+=-=+=-=+=-=+=-=+=-=+=-=+=-=+=-=+=-=+=-=+=-=+=-=
| Ed Korthof | edk@collab.net | 650-228-2527 |
+=-=+=-=+=-=+=-=+=-=+=-=+=-=+=-=+=-=+=-=+=-=+=-=+=-=+=-=

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