[TYPO3-dev] TYPO3 and MySQL Strict Mode

[Martin Kutschker]

Ries van Twisk schrieb:
>>
>> Integer fields can be quoted. This is not a error but a fully valid
>> SQL behavior. In your case this was not a cause of error. The image
>> says that 'temp_content' was invalid.
> 
> 
> in some databases and MySQL in strict mode an integer quoted as a empty
> string will not result in a 0 being added, but generates an error.

And right they are! Sadly TYPO3 relies on this sloppy way of PHP/Mysql
in many places.

> Besides, good practice will be to not quote numbers in general.... (but
> this is out of scope of this mail).

Absolutely no SQL generating code in TYPO3 cares about the column types :(

Masi