Integers columns

[Henry]

Is it possible to have Integer columns in a table, which do not enter a zero into the field if it is left blank?

If so, can this be done with a particular Attribute or an Extra?

I have the Default set to NULL on a series of Int columns receiving data from a survey, but I still get zeros when no choices are made to the corresponding questions in the form once it is submitted.

[sde]

if you are using phpmyadmin, it could be because those colums were not set null at first, and it automatically puts a '0' in there.

then when you make each field NULL, then it retains the default entry that was previously entered.

you will have to go back and type NULL as your default for that table.

now if you're not using phpadmin, .. then yes, it is possible .. the mysql code for adding a field to a table would be something like this:

ALTER TABLE 'db'.'table' ADD 'some_field' INT DEFAULT NULL;

[Henry]

I am using phpmyadmin. When I set up the table, I created the integer columns by typing 'field name' Int, and the table was created with null-yes, default NULL for all of the columns, including the integer ones. I'm not having any problems wiht any of the other columns, when they are left blank on the form, there is nothing entered into the column in the table. The default settings are the same for all of the comumns in the table, but the integer columns are defaulting at zero, in spite of the DEFAULT setting.

Should I just change these columns to enum with the five possible numbers set as the values? It seems like the easiest solution, I just wanted to makle sure that it was the only quick one.

Thanks