Sybase float field

sangi1981 · Post by **sangi1981** » Fri Apr 29, 2011 3:18 am

Hi all,
Using DS8.1, Sybase like source and SqlServer like target I encountered a rounding problem reading float field.
In example, I read a float field with value 0.95, that become 0.949999....
In reference guide there is a note about this behavior, but is there workaround to solve it!?
Thank you very much.

chulett · Post by **chulett** » Fri Apr 29, 2011 6:33 am

Float is float so you'll have issues like this. Can you post the "note" from the reference guide you referred to?

sangi1981 · Post by **sangi1981** » Fri Apr 29, 2011 8:21 am

Thanks for your replay.
This is a link where I found notices about limits reading sybase fields of type float:

http://publib.boulder.ibm.com/infocente ... pport.html

I found a workaround: instead of treat data as float I treat data as double: in this manner there is no truncation.

sangi1981 · Post by **sangi1981** » Fri Apr 29, 2011 8:26 am

http://publib.boulder.ibm.com/infocente ... Types.html