Page 1 of 1

Lost precision float to char

Posted: Thu Feb 01, 2007 8:51 am
by jusami25
Hi experts,

i have a float(16) field with the number like 59330897.3028773 but when i pass to a char(60) i loosing precision and i got 59330897.3029. What can i do?

Thanks in advance.

Posted: Thu Feb 01, 2007 8:58 am
by DSguru2B
Try sending to varchar(). Set the scale appropriately.

Posted: Thu Feb 01, 2007 1:51 pm
by DSguru2B
It would be nice to share the solution with us :roll: