[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