I am using SQL server with ODBC adapter. If I have a field defined as "hair_color string(255) default("UNK"), not null" it causes problems with saving the record if I don't specify the hair color.
In this case if I don't specify a hair color AR puts a NULL into the insert clause and SQL server pukes. If AR simply had left that field out of the insert everything would have been fine.
Is there a way to tell AR to either leave the NULL fields out of the insert (or update) or to load the defaults into the model when it's created?