Re: BLOBs in MySQL: Binary Laughable OBjects?!

Submitted by garaged (not verified) on Thu, 09/13/2007 - 15:17.
from mysql manual :) "If strict SQL mode is not enabled and you assign a value to a BLOB or TEXT column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For truncation of non-space characters, you can cause an error to occur (rather than a warning) and suppress insertion of the value by using strict SQL mode. See Section 5.2.6, «SQL Modes»."

Reply

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <br> <b> <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <blockquote> <img> <h1> <h2> <h3> <tt> <pre> <strike>
  • Lines and paragraphs break automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>. Beside the tag style "<foo>" it is also possible to use "[foo]".

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
    _           _    __   _____   ____  
   (_)  _   _  / |  / _| | ____| |___ \ 
   | | | | | | | | | |_  |  _|     __) |
   | | | |_| | | | |  _| | |___   / __/ 
  _/ |  \__,_| |_| |_|   |_____| |_____|
 |__/
Enter the code depicted in ASCII art style.