List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:December 3 2002 1:51pm
Subject:re: Blob accepts LongBlob without error
View as plain text  
Ryan,
Tuesday, December 03, 2002, 2:04:03 AM, you wrote:

RCGT> I have successfully inserted and retrieved binary image files within
RCGT> MySQL.  No big deal.

RCGT> However, for quite some time I was perplexed because only about half my 
RCGT> image was going through.

RCGT> It seems that MySQL accepts insertion of a string into a BLOB field that 
RCGT> is longer than the maximum length of the BLOB data-type and it will 
RCGT> still accept it.

Yes, and it's mentioned in the manual:
     If you assign a value to a BLOB or TEXT column that exceeds the
     column type's maximum length, the value is truncated to fit.

RCGT> Perhaps MySQL should output an error or at least a warning to know the 
RCGT> string is too long.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




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