FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

Are you using the 0.51 version or the CVS snapshot?  I thought the last
digit truncation was fixed.

Brian

On Fri, 18 May 2001, Nazzareno Pierantozzi wrote:

> 
> 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
> > > > >