Mssql 2008 fails to insert using the insert method due to quotes. Mssql can convert Double and Int but throws an error for money and small money types.

Ex:

Table

CREATE TABLE dbo.testMoney
    (
    id int NOT NULL IDENTITY (1, 1),
    paid money NOT NULL
    )  ON [PRIMARY]
GO

Insert.php

class MoneyTable extends Zend_Db_Table_Abstract
{
 protected $_name = "testMoney";
}

$db = new MoneyTable;

$data = array('paid' => 5.25);
$db->insert($data);

Query Created (taken from sql profiler)

INSERT INTO "testMoney" ("paid") VALUES ('5.25')

This causes Sql Server to fail since the 5.25 is in quotes. The query should be:

INSERT INTO "testMoney" ("paid") VALUES (5.25)