sending null value to database.

Takuma

Hi,
is it possible to send null value to mysql database and not 0 ?
[code]
"label": "Label",
"name": "Name",
"default": null,
[/code]


When I do like above, my database recieves the value 0 and not NULL.

I tried it with
"default": "",
but same result.

Thank you.

tangerine

I think that this is a characteristic of MySQL rather than a Datatables issue.

Have you tried this (only from memory):
1. Make NULL the field's default value in MySQL;
2. When inserting new records, don't send that field anything.

Takuma

I have tried it already. Doesn´t work.

allan

Is it an int type in the db? This SO post seems relevant: http://stackoverflow.com/questions/6918164/empty-string-inserting-a-zero-not-a-null

You might need to use a set formatter if you are using the Editor PHP libraries: http://editor.datatables.net/docs/current/php/class-DataTables.Editor.Field.html#_setFormatter

Allan