From: Dan Nelson
Date: December 3 2004 8:10pm
Subject: Re: if last binary byte is space (ascii 32) mysql drops it
List-Archive: http://lists.mysql.com/mysql/176851
Message-Id: <20041203201053.GA56503@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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
	dnelson@stripped