[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