[TYPO3-dev] [TYPO3] Call for problems: MySQL 5 in TYPO3

[ries van Twisk]

<rant>
	<emotion>Arrrch...</emotion>
	<reason>such a oddity in MySQL.. why can't a TEXT field not have an  
empty string as a default value?</reason>
</rant>

Ries

On Jan 11, 2008, at 10:57 AM, Francois Suter wrote:

> Hi,
>
>> MySQL strict mode postulates to have a DEFAULT value for each column
>> having set NOT NULL (sounds logic, doesn_t it?).
>
> <rant>
> I don't want to start a flame war or derail the discussion, but no, I
> don't find that logical.
>
> A NOT NULL field means that it must absolutely hold a value. But there
> are situations where you can't define a default value. Take the case  
> of
> date fields. MySQL sets a default date to 0000-00-00 which doesn't  
> mean
> anything since it's not real date!
> </rant>
>
> OK, sorry for that, I had to let it out :-)
>
> Have a nice week-end all.
>
> -- 
>
> Francois Suter
> Cobweb Development Sarl - http://www.cobweb.ch
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev

--
Ries van Twisk
Freelance TYPO3 Developer
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/
skype: callto://r.vantwisk
Phone: + 1 810-476-4193