FreeTDS Development Group

[cbone AT newroadstelecom.com]

I am using FreeTDS with Perl on Redhat 7.1 on an Intel platform.
I am having a problem when selecting float data from a mssql7 database.

If the data in the table is not rounded, my Perl script will return the
data without any problem.

If the data in the table is rounded, then the Perl script returns it with
the second decimal place truncated.

Example One:
Table data = 79.129999999999
Statement = 'select float_data from nonrounded_table'
Result using freetds and perl = 79.13

Example Two:
Table data = 79.13
Statement = 'select float_data from rounded_table'
Result using freetds and perl = 79.1

As you can see in the second example, the resulting data is truncated.

Any help would be greatly appreciated.