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

Wasson, Tim WassonT at kochind.com
Wed Jul 5 10:02:13 EDT 2000


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




More information about the FreeTDS mailing list