On Mon, Sep 27, 2010 at 8:55 AM, Chris Riesen <[email protected]> wrote: > I'm in that boat, using PHP on *nix and use FreeTDS to access it > without a hitch. The only falldown I had so far is the size of blob > fields has an incredibly low default value, if you use blobs for > anything thats a couple kilobytes in size or above. Summed that one up > here: > http://christianriesen.com/2010/07/ms-sql-blob-truncated/ >
The final straw that led me to investigate the MS option was a site that we were running at the time that had news articles stored in the database. PDO_MSSQL was limited to only being able to fetch 4KB from a column -- period. Several of the articles were truncated at 4,096 characters when viewed, even though the full content was stored. I tried writing a Zend_Db_Adapter_Mssql to use the original mssql library. You could increase the text size limit with it, but it didn't handle parameterized queries. Given that mssql is being phased out, it just wasn't worth the effort to make it work. We tried PDO_ODBC, and it worked OK for a while, but had some stability issues (as well as there not being a Zend_Db_Adapter_Pdo_Odbc). Granted, there were additional reasons for the instability, but things improved so much when we switched to the MS driver that it gave us plenty of time to reevaluate the rest of our configuration. I have heard that FreeTDS works OK for Linux, but I have almost no experience with it. Andrew
