>> How would you like to use a database that has nuances like these --
>> http://forums.mysql.com/read.php?20,141120,141120#msg-141120
---
> Huh?
> A blank string (does that mean '' or ' '?) is not NULL, so of
> *course* it should pass the NOT NULL constraint.
> Or am I missing something?
---
I agree with you, although Oracle won't, they really blurred the line
between the empty string and NULL.
As for MySQL maybe this article makes more sense:
http://www.databasejournal.com/features/mysql/article.php/3519116
Mike.