Nullable Integer Defaults to Zero

[andres]

DaDaBIK version 10.0-Manarola enterprise
PHP Version: 7.3.24
mysql version: 5.5.55
Web server: Apache

Hello

Is it possible to make some nullable fields (integers, floats and dates) not to default to zero but a null (empty) value instead?

Thank you
Andres

 

[eugenio]

Hello,
you should allow the NULL value for those fields on mysql, if you are getting 0, it probably means NULL is not allowed.

Best,

 

[andres]

Thank you Eugenio

The fields definitions on MySQL are OK. They allow NULL and the default value is NULL as well.

However, in Dadabik these fields default to zeroes and the null checkboxes are not present in the Creation form.

How can we enable these checkboxes?

Regards
Andres

 

[eugenio]

Hello,
check all the "null handling parameters" in config.php

Best,

 

[andres]

Thank you