| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Jan Steinman | Date: | December 3 2002 8:32pm |
| Subject: | Re: Blob accepts LongBlob without error | ||
| View as plain text | |||
>From: "Ryan @ Common Ground . To" <Ryan@stripped> > >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>
| Thread | ||
|---|---|---|
| • Blob accepts LongBlob without error | Ryan @ Common Ground . To | 3 Dec |
| • re: Blob accepts LongBlob without error | Victoria Reznichenko | 3 Dec |
| • SQL Select Idea | Felipe Moreno - MAILING LISTS | 3 Dec |
| • RE: SQL Select Idea | Mike Hillyer | 3 Dec |
| • RE: SQL Select Idea | Jim Esten | 3 Dec |
| • RES: SQL Select Idea | Felipe Moreno - MAILING LISTS | 3 Dec |
| • Re: RES: SQL Select Idea | Michael T. Babcock | 4 Dec |
| • RES: RES: SQL Select Idea | Felipe Moreno - MAILING LISTS | 4 Dec |
| • Re: RES: RES: SQL Select Idea | Michael T. Babcock | 4 Dec |
| • RES: RES: RES: SQL Select Idea | Felipe Moreno - MAILING LISTS | 5 Dec |
| • RE: SQL Select Idea | Jim Esten | 4 Dec |
| • Re: Blob accepts LongBlob without error | Jan Steinman | 3 Dec |