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
On Thursday 13 January 2005 12:42, Mads Kristensen might have typed:
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
;-)
http://dev.mysql.com/doc/mysql/en/String_type_overview.html
--
MySQL
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
Mads Kristensen [EMAIL PROTECTED] wrote on 13/01/2005 12:42:13:
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