Ok. I am replying to my own post here ;-)
I guess that the reason is the fact that only 2 bytes are reserved for storing the size of the BLOB, and since an unsigned short's maximum value is 2^16-1 this is also the maximum size of the BLOB.
So, mystery solved :-)
- Mads
Mads Kristensen wrote:
Is it true that I can only store 65535 bytes (2^16-1) in a field of type BLOB? I thought that a BLOB was supposed to be able to hold 2^16 bytes of data.
If it is indeed only possible to store 2^16-1 bytes I would like to know why this has been implemented in that way (yes, I am always this curious ;-)
Best regards, Mads Kristensen
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
