[TYPO3-dev] Bugfix 12428 is buggy for me: 'No TypoScript template found!'

[Martin Kutschker]

Bernhard Kraft schrieb:
> Steffen Kamper wrote:
> 
>>
>> it was mediumblob before too (older revisions)
>> blob and mediumblob don't vary much, they have variable length, but
>> mediumblob saves 2 bytes :)
> 
> Hello Steffen,
> 
> I have to correct you. the BLOB/TEXT types and the MEDIUMBLOB/MEDIUMTEXT
> types vary quite a lot when it comes about storage space. From mysql
> documentation:
> 
> BLOB, TEXT:
> L + 2 bytes, where L < 2^16
> 
> MEDIUMBLOB, MEDIUMTEXT
> L + 3 bytes, where L < 2^24
> 
> 
> So a BLOB/TEXT can store a maximal of 2^16 = 65536 bytes (64kByte)
> whilst a MEDIUMBLOB/MEDIUMTEXT can store up to 2^24 = 16MByte of
> information.
> 
> Another thing is, that TEXT fields (TINY, normal, MEDIUM and LONG) can
> get compared using LIKE functions, or other mysql stuff, whilst the BLOB
> types can only get stored and retrieved.

It makes (in normal operations) little sense to use LIKE on a serialized array or on cache content.

For debugging purposes you can still make a type cast in your queries.

Masi

PS: For Mysql we could use VARBINARY(255) instead of a TINYBLOB, but does that solve any problems?