[Typo3-dev] NOT NULL for some columns in tt_address

[Dimitri Tarassenko]

Karsten,

> Have you ever *really read* the MySQL manual? No offense, I didn't for
> a long time :). 

No, do you think I should? ;)))

> Their notion of NOT NULL is somewhat crude, so the
> above makes perfect sense to them - the default is an empty string.

I'd say it's rather peculiar. So, a NOT NULL field always has an 
implicit default defined? And that default is not exported when you do a 
mysql dump? Interesting, interesting.

> In fact, NOT NULL in MySQL *always* allows you to insert without
> specifiyng the field, it just means the field will not be NULL
> afterwards, but the 'internal standard default' (my name for it),
> being either '' or 0, IIRC.
> 
> That's why... :)

Interesting. The problem that I have encountered is with a third-party 
MySQL client that apparently pre-validates the data based on the 
database scheme before attempting to insert - EMS MySQL manager. When 
trying to add a record there it prompts me for these three fields.

Oh well, the wonderful world of MySQL :)))

Thanks for clarification, that helped a lot!

Dimitri