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 errorRyan @ Common Ground . To3 Dec
  • re: Blob accepts LongBlob without errorVictoria Reznichenko3 Dec
    • SQL Select IdeaFelipe Moreno - MAILING LISTS3 Dec
      • RE: SQL Select IdeaMike Hillyer3 Dec
      • RE: SQL Select IdeaJim Esten3 Dec
        • RES: SQL Select IdeaFelipe Moreno - MAILING LISTS3 Dec
          • Re: RES: SQL Select IdeaMichael T. Babcock4 Dec
            • RES: RES: SQL Select IdeaFelipe Moreno - MAILING LISTS4 Dec
              • Re: RES: RES: SQL Select IdeaMichael T. Babcock4 Dec
                • RES: RES: RES: SQL Select IdeaFelipe Moreno - MAILING LISTS5 Dec
        • RE: SQL Select IdeaJim Esten4 Dec
Re: Blob accepts LongBlob without errorJan Steinman3 Dec