How to send 0 value for non selected checkbox

If I select my checkbox in my form the value 1 is being saved into the database. If the checkbox is not selected the value NULL is submitted. How do I send the value 0 to the database when the checkbox has not been submitted?

Thanks for any help

in the insert and update record behavior, selct the column that the checkbox is bound to and set the data type to "Checkbox 1,0"

Thx Jason, missed that ... ;-)

It doesn't seem to work. I have 2 form pages one with the form fields, one with an overview and hidden fields that contains the insert behaviour. It looks like that the checkbox from the first form field is not submitting a 0 value if the checkbox has not been selected:

<input type="checkbox" name="Catering" id="Catering" value="1" class="formCheckboxField_Standard" <?php if (!(strcmp((isset($_GET["invalid"])?ValidatedField("resformular2","Catering"):""),"1"))) {echo "checked=\"checked\"";} ?> tabindex="10">

Therefore I do always get a 1 into the database. Any ideas what might go wrong here?

This post has been deleted.

Got the solution, added "0" to:

<input name="HCatering" type="hidden" value="<?php echo((isset($_POST["Catering"]))?$_POST["Catering"]:"0") ?>">

and on the insert behaviour went back to "integer"