I am using perl 5.005 and Informix dynamic server 9.21.UC3.  I built a
version of DBD::Informix 1.00.PC1 using Informix clientsdk 2.20UC1 and
everything worked great, then I built a version using Informix clientsdk
2.50UC2 and when I retrieve values that are defined as 'float' from the
database they come back as different numbers:

The ouput below is from two seperate queries:
'select name, num from data_table'
'select name, num::smallfloat from data_table'

output from a script using DBD::Informix built with clientsdk 2.20UC1:
Select data from temp table...
Name: joe       , Num: 15.75
Name: john      , Num: 114.04
Select data from temp table...
Name: joe       , Num: 15.75
Name: john      , Num: 114.04

same script using DBD::Informix built with clientsdk 2.50UC2:
Select data from temp table...
Name: joe       , Num: 15.75
Name: john      , Num: 114.04000000000001
Select data from temp table...
Name: joe       , Num: 15.75
Name: john      , Num: 114.040001

I looked through the Notes/* and README files, but I don't see anything
that mentions this type of problem.  Has anyone else seen anything like
this?

-=hugh



Reply via email to