[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