Skip to Content.
Sympa Menu

freetds - Re: Problems with floats with php/mssql 7

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Myers Carpenter" <myers AT fil.org>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: Problems with floats with php/mssql 7
  • Date: Fri, 23 Feb 2001 12:01:00 -0500 (EST)


I think this is another php4 bug (Looks like I'm going to have to fix them
as no one seems to be giving the mssql driver much loving :)). With or
without this patch I can use sqsh and get the right answer.

myers

> I had a similar problem. When I looked at the code and compared the
> functions tds_process_result() and tds7_process_result() I found that
> the following was lacking from the tds7 version:
>
> if (is_numeric_type(curcol->column_type)) {
> info->row_size += sizeof(TDS_NUMERIC) + 1;
> }
>
> I posted the bug on here and someone told me the patch had already been
> submitted but perhaps it's still just in the CVS archive. It comes
> right after this line in that function:
>
> curcol->column_offset = info->row_size;
>
> Regards,
>
> Gerry
>
> Myers Carpenter wrote:
>
>> Another intresting problem: When I SELECT a float column (actually
>> I'm "SELECT *"'ing the whole table, which include floats.) I get "12"
>> where the value in the database is "123".
>>
>> This is using TDS 7.0 (specified in the interface file) talking to a
>> MS SQL 7sp2 database.
>>
>> Any ideas?
>>
>> myers






Archive powered by MHonArc 2.6.24.

Top of Page