>From: "Ryan @ Common Ground . To" <[EMAIL PROTECTED]> > >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.
I think this is a responsibility of the front-end, NOT the database. Surely, if you're using anything but human-typed SQL to enter this data, it has a better opportunity for data checking that the database does. ---- SQL SQL SQL SOL... ---- -- : Jan Steinman -- nature Transography(TM): <http://www.Bytesmiths.com> : Bytesmiths -- artists' services: <http://www.Bytesmiths.com/Services> : Buy My Step Van! <http://www.Bytesmiths.com/van> --------------------------------------------------------------------- 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