Skip to Content.
Sympa Menu

freetds - Re: Hungry PHP

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT umcc.ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Hungry PHP
  • Date: Mon, 13 Sep 1999 08:36:20 -0400 (EDT)



Well, it seems to be the same issue in that you have a null in the output
stream. However, dbdatlen() shouldn't come into play here, so it's a
different cause (but same result). I'll look into later day (getting ready
to drop my son off at school now, so I only have a minute).

I've got a few ideas, I'll post back to the list if any of them pan out.

Brian

On Mon, 13 Sep 1999, Paul Schaap wrote:

> Brian,
>
> > Ok, looking at things, I may not need to be so drastic. PHP does something
> > like this:
> >
> > res_length = dbdatlen(dbproc, offset);
> > dbconvert(NULL,coltype(offset),dbdata(sybase_ptr->link,offset),
> > res_length,SYBCHAR,res_buf,-1);
> >
> > So it should indeed null terminate them (the -1 means to null term the
> > result), however dbdatlen() returns an incorrect value. I fixed that and
> > also fixed it for the NULL case as well. I'm going to try all the test
> > cases tommorow on a real dblib machine and then I think I should be able
> > to fix the other cases. But try the latest CVS and let me know.
> >
> > Brian
> >
>
> 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 :-(
>





Archive powered by MHonArc 2.6.24.

Top of Page