Blob accepts LongBlob without error

[Ryan @ Common Ground . To]

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


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