FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

Paul,

Are these fields datetime or smalldatetime? I found a problem with
smalldatetimes that seems to happen with PHP more than sqsh, and fixed
that in CVS. Solaris is bus erroring (alignment problem) on me and I
haven't been able to track that down quite yet, so I'm kinda feeling my
way through this as best I can for the moment.

As far as things that fix sqsh and not php, I'm really not surprised.
They process things quite differently, which is great from my perspective
because it gives me a broader range of code to look at, but unfortunately
it also means not all fixes apply equally.

Cheers,

Brian

On Mon, 13 Sep 1999, Paul Schaap wrote:

> For the VARCHARS this is now OK. Back onto the DATETIME issue, certain in
> the knowledge that the library IS dynamically compiled, I have done a 
> little more testing to reveal that DATETIME data is also hungry ! Could 
> you
> safely apply this patch to the DATETIME data types ?
> 
> As I mentioned before using sqsh worked perfectly but php did not. 
> Therefore I tried a full recompile apache and php against the working 
> freetds from scratch to no avail. I therefore think the next question is 
> if
> datetimes are being treated differently, or, if the hungry issue is the 
> cause, or, if we should bother wasting any more time on it ?
> 
> >From php ...
> ID       Raw                 Converted
> 10001486 Feb 25 2003 03:50AM Sep 13 1999 4:15PM
> 10001485 Jan 29 2003 03:50AM Sep 13 1999 3:48PM
> 10001484 Jan 10 2003 03:50AM Sep 13 1999 3:29PM
> 10001483 Nov 24 2002 03:50AM Sep 13 1999 2:42PM
> 10001480 Jun 03 2002 03:50AM Sep 13 1999 11:48AM
> 
> >From sqsh ...
>  ID        DateAdded
>  -------- ------------------- --------------------
>  10001486 Sep 13 1999 04:15PM Sep 13 1999  4:15PM
>  10001485 Sep 13 1999 03:48PM Sep 13 1999  3:48PM
>  10001484 Sep 13 1999 03:29PM Sep 13 1999  3:29PM
>  10001483 Sep 13 1999 02:42PM Sep 13 1999  2:42PM
>  10001480 Sep 13 1999 11:48AM Sep 13 1999 11:48AM
> 
> I'm also concerned any change to fix the php link may affect sqsh :-(
>