[TYPO3-core] BLOBs and Oracle ...again

Franz Holzinger franz at fholzinger.com
Mon Jul 17 16:09:38 CEST 2006


Hello Martin,

>Franz Holzinger schrieb:
>  
>
>>>and getting rid of all other BLOBs in 4.1 that contain no real binary 
>>>data.
>>>      
>>>
>>which ones ?
>>    
>>
>
>Eg group membership of be_users and fe_users. They are simply strings (and 
>should be normalized anyway).
>
>TYPO3 stores no binray data. BLOBs are always used where the contents is 
>likely to be no natural speech, but this is no good reason to use a BLOB. 
>At least in Oracle as it stores them differently optimized for huge chunks 
>of data.
>
>  
>
This would be fine.
However group memberships should go into a mm table. But then it would 
not remain compatible.

So it should become a mediumtext for 4.0.1, but a mm-table for 4.5.x.


- Franz






More information about the TYPO3-team-core mailing list