[dev] kronolith MS-SQL support patch proposal

[Chuck Hagenbuch]

Quoting Ben Chavet <ben at horde.org>:

> I'm going to go with a "yes, it's really impossible".  Here's the   
> kicker: if I echo the query just before it is executed, copy & paste  
>  that into the MS-SQL console, I get different results.  The query   
> works fine in MS-SQL, returning the desired rows.  But, it returns 0  
>  rows every time with php.  The only explanation I can come up with  
> is  that the "meaning" of the datetime comparison value must be  
> getting  lost somewhere in the communication between php & mssql  
> (ie. by the  time it gets to mssql, it thinks it's a string, or  
> something like  that).  Of course, that's only a speculation, but  
> it's all I've got.

Sounds a lot like we need to set the date format in the db "session"  
correctly, like we already do for oci8 and pgsql in the _initConn()  
function.

> There's surprisingly little information on this subject.  Apparently  
>  php+mssql isn't a very common combination...

Considering that you can't even talk to the latest MSSQL from PHP  
without ODBC, I'm not surprised...

-chuck

-- 
"we are plastered to the windshield of the bus that is time." - Chris