Re: NOT NULL fields in INNODB Tables

* Donal Murtagh > My DB consists of INNODB tables, such as... > > > CREATE TABLE user > ( > name VARCHAR(255) NOT NULL > > ) TYPE = INNODB; > > > The NOT NULL qualifier doesn't have the effect I expected. Although I > can't do this... > > INSERT user VALUES (null); > > > I can do this: > > INSERT u

NOT NULL fields in INNODB Tables

Greetings, My DB consists of INNODB tables, such as... CREATE TABLE user ( name VARCHAR(255) NOT NULL ) TYPE = INNODB; The NOT NULL qualifier doesn't have the effect I expected. Although I can't do this... INSERT user VALUES (null); I can do this: INSERT user VALUES (""); I appreciate