Hello ,
VERSION 3.23.49
mysqldump incorrectly export char/varchar binary and *BLOB fields.
it export binary fields like text strings
example :
CREATE TABLE users (
US_ID int(10) unsigned NOT NULL auto_increment,
USERNAME varchar(16) NOT NULL default '',
US_ACTIVE tinyint(3) unsigned NOT NULL default '0',
US_SECRET0 tinyblob,
US_SECRET1 tinyblob,
US_AUTHKEY tinyblob,
US_PUK tinyblob,
US_CARDID varchar(16) binary NOT NULL default '',
PRIMARY KEY (US_ID),
KEY x_username (USERNAME),
KEY x_cardid (US_CARDID),
KEY x_active (US_ACTIVE)
) TYPE=InnoDB;
INSERT INTO users VALUES (7,'zk',1,'��bv','� +:��','�]��\ZW�{','T~�x��-','T
�c�S�G\"R-���');
this is obviously incorrect and may contain non-asci characters.
I experienced corrupt records in practice.
You should use hex representation, for example :
INSERT INTO users VALUES (7,'zk'',1,binary 0x112233,binary
0x44556677,.................);
or at least escape sequences in text strings
--
Best regards,
Papa mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
