From: Ryan @ Common Ground . To
Date: December 3 2002 12:04am
Subject: Blob accepts LongBlob without error
List-Archive: http://lists.mysql.com/mysql/126349
Message-Id: <3DEBF4F2.9060609@CommonGround.To>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

I have successfully inserted and retrieved binary image files within 
MySQL.  No big deal.

However, for quite some time I was perplexed because only about half my 
image was going through.

It seems that MySQL accepts insertion of a string into a BLOB field that 
is longer than the maximum length of the BLOB data-type and it will 
still accept it.

Perhaps MySQL should output an error or at least a warning to know the 
string is too long.

Thanks much,

-Ryan Hatch