In the last episode (Dec 03), Mark Maunder said: > This all started when one of the 16 byte binary primary keys kicked out > a duplicate key error. It seems mysql does not store the last byte of > the binary value if it is a space. That is, ascii 32 or hex 20. > > How do I force it to store the space? Thanks! > > create table testtable ( id binary(16) NOT NULL PRIMARY KEY ) ENGINE=MyISAM;
There is no native mysql BINARY type; it's mapped to CHAR(n) BINARY. CHARS and VARCHARS trim trailing blanks (A known issue, but low priority I think). Try using a TINYBLOB column type instead. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]