[TYPO3-core] RFC: #0012381: Bug: Change definition of DB table fields
Francois Suter
fsu-lists at cobweb.ch
Wed Oct 28 15:35:51 CET 2009
Hi,
> Problem:
> The fields "serialized_task_object" & "serialized_executions" are
> defined as "TEXT" this can be a problem with charset convertion from
> database to your system.
>
> Solution:
> It is a good practise to define such serialized fields as "BLOB" because
> this is a binary field where no charset convertions are made on.
>
> So just, change the fields from "TEXT" to "BLOB".
There's has been a move in recent years to use TEXT fields throughout
the TYPO3 core rather than BLOBs. If you look at all the cache tables,
they use TEXT fields. So I would rather tend to leave the fields as is.
What do others think?
Cheers
--
Francois Suter
Cobweb Development Sarl - http://www.cobweb.ch
More information about the TYPO3-team-core
mailing list