Skip to Content.
Sympa Menu

freetds - RE: Problem with float-Fields using FreeTDS and PHP4 wi th MS SQL 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Wasson, Tim" <WassonT AT kochind.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: Problem with float-Fields using FreeTDS and PHP4 wi th MS SQL 7.0
  • Date: Wed, 5 Jul 2000 09:02:13 -0500


I've tried hitting MS SQL 7.0 desktop from Linux/Apache/PHP3 and all the
floats I had were coming through as zeros. Switched to reals and they work
fine.

Not a real fix, but another data point

Tim Wasson
Koch Industries
Wichita, KS

> -----Original Message-----
> From: Karsten Wegmeyer [SMTP:wegmeyer AT talknet.de]
> Sent: Monday,July 03,2000 2:22 AM
> To: TDS Development Group
> Subject: [freetds] Problem with float-Fields using FreeTDS and PHP4
> with MS SQL 7.0
>
<snip>

> I can't access fields that are declared as float. doing a direct access
> via select price from table results in strange numbers like
> 14.08945123344 where the entry really is 2790.00.
> using convert(char(12),price) produces randomly correct Prices with
> some results containing nonsense like "(a|ยง..." and a segmentation fault
> after x processed rows ( x < 10). Even a convert(int,price) does not work!
>
> Has anyone an idea how to cope with float-Fields from PHP4 via freeTDS ?
>
> Thank you
>
> K. Wegmeyer
>
> ---
> You are currently subscribed to freetds as: WassonT AT kochind.com
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>




  • RE: Problem with float-Fields using FreeTDS and PHP4 wi th MS SQL 7.0, Wasson, Tim, 07/05/2000

Archive powered by MHonArc 2.6.24.

Top of Page