From: Jan Steinman Date: December 3 2002 8:32pm Subject: Re: Blob accepts LongBlob without error List-Archive: http://lists.mysql.com/mysql/126455 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" >From: "Ryan @ Common Ground . To" > >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): : Bytesmiths -- artists' services: : Buy My Step Van!