the data type double means a double byte integer
In the insert record behavior, that column would be set as numeric.
the insert behavior will use
floatval()
to ensure that text is not injected to a numeric column to prevent SQL injection.
when the string is empty, the flaotval() of "" is 0