[TYPO3-core] RFC Bug #14152: Table sys_log, field details is too small

Christian Kuhn lolli at schwarzbu.ch
Mon Apr 19 21:58:38 CEST 2010


Hey.

Jigal van Hemert wrote:
> VARCHAR can be bigger than 255 these days, so why not set it to a 
> sensible size? Fields shouldn't be larger than needed.

Yes, tought about that, too. But:
a) mysql <5.0.3 (which is still allowed in our version matrix) doesn't 
support varchar > 255, and
b) mysql in strict mode throws an error if the inserted string is > 
maxlength (we already have several strict mode issues and I don't want 
to introduce another one). Thus we would have to crop in php which isn't 
so easy because we afaik don't have an -always used- api to this table 
(except writeLog).

Keeping that in mind it was too much hassle for this simple issue, so I 
proposed text, which is a save bet here.

Regards
Christian


More information about the TYPO3-team-core mailing list