revathskumar/CakePHP-sqlsrv-driver — Issue #7: forcing blank integer, float and binary to be NULL
Author: ianchanning
Created: 2011-10-12 13:29:49+00:00
State: open

In the value function (when compared to dbo_mssql.php) the following code has been added (lines 334-336):

if (in_array($column, array('integer', 'float', 'binary')) && $data === '') {
return 'NULL';
}

I think that this code agrees with what the mysql driver does. However in my application this produced an error.

This is possibly a more correct way of doing things, but I think the switch from mssql to sqlsrv should not produce errors. Thus code like this should remain the same as mssql until this is changed in both libraries.