FreeTDS Development Group

["Nazzareno Pierantozzi" <npierant AT medimatica.com>]

Well,
the ms sql data type is Float(lengt 8,precision 53),the data value that is
in the database is 908564150005(is a java long). Using  Php4.0.5 function
"mssql_result" or "mssql_fetch_row" or "mssql_fetch_array" I get  the value
90856415000: the original value has 12 digit, the value that I get is 11
digit.
I made another test: if I put in the database 87777.67 I get 87777.6.
If you want I can give you all the references for accessing in this database
so you can test better: let me know.

Thanks in advance for your help.

----- Original Message -----
From: "Brian Bruns" <camber AT ais.org>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Friday, May 18, 2001 8:52 PM
Subject: [freetds] Re: Php4-Freetds-Apache-Linux


> Ok,
>
> Your statement of the problem is a little vague.  Can you be more specific
> about what you mean by "the data is cut".  Provide some examples of what
> you are expecting and what is actually being returned.
>
> Brian
>
> On Fri, 18 May 2001, Nazzareno Pierantozzi wrote:
>
> > I think that there is not this the problem because I configured php4
> > "--with-sybase-ct=shared,/usr".
> > ----- Original Message -----
> > From: "Brian Bruns" <camber AT ais.org>
> > To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
> > Sent: Friday, May 18, 2001 6:36 PM
> > Subject: [freetds] Re: Php4-Freetds-Apache-Linux
> >
> >
> > > If you are using the dblib version of php (--with-sybase), PHP has a
bug
> > > with float or real types (can't remember which)...If so, I'd try using
> > > --with-sybase-ct (see the FreeTDS users guide for build
> > > instructions) instead and see if that works.
> > >
> > > Brian
> > >
> > >
> > > On Fri, 18 May 2001, Nazzareno Pierantozzi wrote:
> > >
> > > > I need to connect to MS sql from linux.
> > > > The connection to MS sql server 7.0/2000 using
Php4-Freetds-Apache-Linux
> > > > works well.The problem begins when I try to get float data from MS
SQL
> > > > sever:the data are cut!! Do you know a solution for this problem? I
> > would
> > > > like to know at least which of these modules(Php4 or Freetds)creates
the
> > > > problem in order to eventually try to resolve it.
> > > >
> > > > P.S.:excuse me for my English
> > > >
> > > > ---
> > > > You are currently subscribed to freetds as: [camber AT ais.org]
> > > > To unsubscribe, forward this message to
> > $subst('Email.Unsub')
> > > >
> > >
> > >
> > > ---
> > > You are currently subscribed to freetds as: [npierant AT medimatica.com]
> > > To unsubscribe, forward this message to
> > $subst('Email.Unsub')
> >
> >
> > ---
> > You are currently subscribed to freetds as: [camber AT ais.org]
> > To unsubscribe, forward this message to
$subst('Email.Unsub')
> >
>
>
> ---
> You are currently subscribed to freetds as: [npierant AT medimatica.com]
> To unsubscribe, forward this message to
$subst('Email.Unsub')