[TYPO3-core] RFC: Getting rid of blob fields in TYPO3 databases

[Martin Kutschker]

Ingmar Schlecht schrieb:
> Martin Kutschker wrote:
>> There are still BLOBs in system extensions:
>>
>> ../typo3/sysext/cms/ext_tables-index.sql
>> ../typo3/sysext/cms/ext_tables.sql
>> ../typo3/sysext/cms/ext_tables_static+adt.sql
>> ../typo3/sysext/dbal/ext_tables.sql
>> ../typo3/sysext/sys_action/ext_tables.sql
>> ../typo3/sysext/indexed_search/ext_tables.sql
>> ../typo3/sysext/impexp/ext_tables.sql
>> ../typo3/sysext/tsconfig_help/ext_tables.sql
>> ../typo3/sysext/tsconfig_help/ext_tables_static+adt.sql
>>
>> Shall we change them too? Note that there is a bu report for FE sessions
>> (#4628).
> 
> If they just contain those comma lists as well: Yes, please.

No, it really depends on the fields. Eg the cache contains HTML 
(snippets) and the FE session contains IMHO serialized "application" 
data. IMHO most if not all those fields will contain some kind of text 
data, but it has to be checked.

Masi